Hi
I have a program that uses a MS Access database. The database has 2 tables
in it . Customers and Orders. I have one problem that I have not been able
to figure out.
I need to change the "Status" field In the Orders table on selected records.
for example I want the user to be able to select the vender from a combo
box, then click a button at this time my program needs to select all orders
with this vender which have a status of open. Then I need these items to be
printed and change the status to ordered.
I would appreciate any help I could get on this.