Updating a field in an active table with a macro

[GregoryWest]

I have a form open, and a large query behind it. What I want to do is update the current record of one Table-Field from True to False in a macro. I have looked at an update query but that looks worse as I only want to update the current record not a selection.

Any ideas?

 

[llkhoutx]

Use an update query. I adhor macros because one has to drill down into them to see what they do. Queries, of any kind, if properly constructed, are usually immediately evident what they do by viewing the query in design view.