-
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.
-
I don't know your tables structure, but try use following SQL with your modificiations:
Select * From Orders Where Customer = '" +Combo1.Text+"' And Status = True
I hope Status Field is Boolean Type. Drop me a line if you want know more.
------------------
The Bozena
