Update tables based on criteria

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

Shawna

I have a function that is using SQL to update two tables
but I can't get my criteria to work so it is taking the
records from all the original tbls and updating to new
tables. I.e. On a P.O. I have a cmd button to create the
receipt record in a header and details table, but it is
sending the information for all P.O.'s not just the
current P.O. - can I filter somehow? My current attempt
for the "where" clause is not working.

Any suggestions is appreciated. Thanking you in advance.
 
Hi Shawn

If you tell me what you've got in your where clause, I might be able to tell you what's wrong with it. It quite often just doesn't work because of missing or extra characters

Donna
 
Back
Top