Updating 2 tables

  • Thread starter Thread starter Shawna
  • Start date Start date
S

Shawna

First Excuse this msg if it comes up twice, I thought I
posted earlier but hasn't shown yet so I might have hit
cancel by mistake. I would like to update two tables
based on information entered into another table via a
form. i.e. A user is on PO #1. I have a cmd button which
runs a macro to run SQL in VB which creates an entry into
a ReceiptHeader and ReceiptDetails table. My problem is,
I'd like it to just update those tables with the
information related to PO #1 - not all PO's. I can't get
the "WHERE" criteria right in my Update queries to do
this.

Any help is appreciated.
 
This problem very often occurs when you have a string variable. Make sure
you have all the operators correctly written in the right place. For
instance Where []='" & stringVaraible & "'"
 
Back
Top