F
fdco
Guest
I am trying a new format with my Order Details table.
What I am looking for is some code that will search the order
details table and see if an item exists in it. If it does I
want the values from another table to be added to that record.
If there is no record there I would like to append a record.
I know I need two queries, an update and an append query. I have
them done but I don't know how to write the VB that will search
the order details table and decide (and run) whatever query is
needed. Any code offered will be appreciated.
Thanks
What I am looking for is some code that will search the order
details table and see if an item exists in it. If it does I
want the values from another table to be added to that record.
If there is no record there I would like to append a record.
I know I need two queries, an update and an append query. I have
them done but I don't know how to write the VB that will search
the order details table and decide (and run) whatever query is
needed. Any code offered will be appreciated.
Thanks