Update tables based on criteria

[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.

 

[Guest]

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