Data entry on form only updates one record on table

[HeatherMichelle]

Hi! I am having a problem with a form I have created to update a table. The form pulls data from the table based on the check number that the user entered and then the user updates data for that check. The problem is that each check might have more than one line on the table (these are accounts payable checks that are paying more than one invoice). I need the updates from the user to update all lines for that check on the table. Any ideas?

 

[Zaeed]

build an sql update query that makes the changes WHERE CheckNum = fld_checkNum

 

[HeatherMichelle]

Thank you for your response. I am a SQL newbie and could really use a little more direction. Can you provide a little more of what the code should look like?

 

[Zaeed]

can you attach your db so i can take a look

 

[HeatherMichelle]

It is ok, I took care of it with an update query. But I thank you very much for pointing me in the right direction. I never would have thought about using the update query if I hadn't started researching how to do a a sql update query. Like I said, I am not good with sql but if a regular query can be built I will figure it out. Thank you again.