Create Drag and Drop Access Form

Must use Microsoft Access 2010.

Need to Create a Drag and Drop form.

See details below.

## Deliverables

See Query1 shows relationship of tables.

These are the Form Controls

- Combobox1 list all ProjectNames in [url removed, login to view]

Defaults to first one on load

- Listbox1 list all = ProjectID for Project Selected in Combobox1

Columns: Code ModuleRate Quantity

- Combobox2 list all ProjectNames in [url removed, login to view] except for the one selected in Combobox2

- Listbox2 list all = ProjectID for Project Selected in Combobox2

Columns: Code, ModuleRate, Quantity

- Drag and drop item from Listbox1 to Listbox2.

Updates the projectID in ProdAllocated and refresh Listbox1 and Listbox2

Update Timestamp to date/time.

- Drag and drop item from Listbox2 to Listbox1.

Updates the projectID in ProdAllocated and refresh Listbox1 and Listbox2

Update Timestamp to date/time.

Microsoft Access Windows Desktop

Projektin tunnus: #2776692

Tietoa projektista