Updating between forms

[Trevor Howard]

I could do with your help

I have a “delivery” form/table, with a sub form “order detail”. What I want to do, possibly via a combo, is to pick an item from the “products” table and update it to the “order detail” sub form, and on exit or with a command button, change the status of the item in the products table from a “stock” to “sold” item.

I don’t know if this is possible or if anyone has any suggestions. I have been struggling with different ideas but just not getting it.

Thanks!
Trevor

 

[Trevor Howard]

Pat,
just what I needed. Thank you!

 

[Trevor Howard]

Hello Pat

I have tried your suggestions, I just cant get a query to update “order detail” from “products”. I am really struggling with this. Could it be my table construction is faulty?? Or I am just not getting it! I have attached a slimmed down version of my db.

Very confused

Trevor