Recording information on a form for two different tables

[springa]

I have two tables, one for inventory movements and the other for orders.
The orders table has columns Order Number, Item ID, Quantity, Order Date, Date Required and Order Completed (Yes or No Checkbox).

I have created a query to show outstanding orders, and have included all the information from these orders in a list box on my Inventory Movements Form so that users can simply click the outstanding Orders record and here's the part I can't get:
On completing the information on the Inventory Movements form, I would like the form to update the selected Orders record as a "Yes" to indicate that the order is completed?

Thanks for your help!

 

[ezfriend]

If you can select each order on the form, bascially you know what the Order Number is. What you need is probably something simple like a button to send an update SQL to the Order table to update that particular order.

 

[CEH]

If I'm reading your post correctly... First, you need to decide what information or field being completed constitutes "completing the information" then upon completion.... if a field, I would put on the afterUpdate event... Me.OrderCompleted = True ("OrderCompleted" being your checkbox field.)