Update the current record.

[Access_Blaster]

I use a query to find matching records, after the record is found I want to update the Boolean field for that record. I am trying to use the following code. As you can see it updates all records within that field. I need to specify the current record. Any help is appreciated.

CurrentDb.Execute ("UPDATE TBL_Vendor SET TBL_Vendor.Active = -1;"), dbFailOnError

[pbaldy]

Along the lines of

CurrentDb.Execute "UPDATE TBL_Vendor SET TBL_Vendor.Active = -1 WHERE KeyFieldName = " & Me.KeyFieldName, dbFailOnError

Using the actual field and control names.

[Access_Blaster]

Thanks Paul, I neglected to mention I was dealing with a list box, after figuring out my ID was in column (0) it worked.. thank for pointing me in the right direction.

[pbaldy]

No problem.