Recent content by JenB

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

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

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.