Search results

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.