Afternoon all,
I've been battling with this, and can't seem to find a solution on the net. I have a form called "WHDispatch", on this form I have a list box ("NewOrders") based on a query listing outstanding orders, with the following fields: "Order Number", "Item ID", "Quantity", "Order Date" & "Date Required".
On selecting a record in this listbox, I would like this to do following:
Store "Order Number" and "Item ID" in their respective fields in "Inventory Movement" table on closing the form. I have been trying to get the listbox to update other textboxes on the form with this information as a possible workaround but have had no luck there...
Any help would be greatly appreciated! Thanks so much!
I've been battling with this, and can't seem to find a solution on the net. I have a form called "WHDispatch", on this form I have a list box ("NewOrders") based on a query listing outstanding orders, with the following fields: "Order Number", "Item ID", "Quantity", "Order Date" & "Date Required".
On selecting a record in this listbox, I would like this to do following:
Store "Order Number" and "Item ID" in their respective fields in "Inventory Movement" table on closing the form. I have been trying to get the listbox to update other textboxes on the form with this information as a possible workaround but have had no luck there...
Any help would be greatly appreciated! Thanks so much!