I am developing a form that will allow the user to maintain a "Orders in Review" table. I added 2 List Boxes one for "Open Orders" and one for "Orders Review" with Order # being the common key field. The idea is if the user selects an item in the Open Orders List then an append query would run to add that orders approriate fields to the Orders Review table. If an item is selected in the Orders Review list then that order would be deleted from the Orders Review table. I thought of having Add and Delete Command buttons but I could have one Update Command button and drive it based on which List Box was selected. How do I populate a variable with the selected Order # so I can pass it to a Query?
Hope this makes some sense.
As always, thank you for any help or information.