Update Query for single record in a form

[JenB]

I have a form that when you choose a name a macro runs an update query to give date from another table and then populates the form. I want to tell the macro to only run on the current record not the entire table that is linked to the form.

 

[BobMcClellan]

Jen,
include a where param in the update query so that it updates only the row you want.
Update YourTable
Set YourColumn = 'x'
where ID = YourParam

 

[JenB]

I have a macro running that when you choose a name in a form it does the update query to return a number. I only want the update query to run on the new record input in my form. Then when I enter a new record in my form I want that record to update not the entire table

 

[BobMcClellan]

I have a macro running that when you choose a name in a form it does the update query to return a number. I only want the update query to run on the new record input in my form. Then when I enter a new record in my form I want that record to update not the entire table

Jen,
Please reread my 1st reply. Simply make the update query do what you want it to do.
If you want it to update 1 row, then include the where parameter so that's exactly what happens.

 

[JenB]

But I want it to only update a new entry in the form. It isn't a set row.