How to update a table from a command button on a report.

[ebrommhead]

I have a table that holds information about customer collection efforts. Each effort has its own id, verbiage, entry date and follow up date (if necessary). I have a report that shows all efforts that have a follow up date. I also have put a resolved button on this report, so that if the effort is resolved they can click it to update the table and it will not show on future reports. The problem is that I can't get the button to update the table with the resolved current date.

Appreciate any help.

[June7]

Show the code you attempted so it can be analyzed.

Is the 'resolved' field a datetime? Probably can do something like:

CurrentDb.Execute "UPDATE tablename SET fieldname=Now() WHERE ID=" & Me.ID