Hi, you can achieve this by creating a new update query that updates the field "blnSent" to true for all records in the table (ask if you are not sure about that bit). Save the query.
Once the query is set up, create a new macro that opens (i.e. runs) this query and then re-querys the form (a "requery" has the same impact as closing and opening the form, if you don't do it then the changes from the update query won't show on the form). Save the macro.
On your form, create a new command button and have it run your macro. Save the form and test it.
You might also want to look at adding a few more lines to your macro e.g. turn off the echo at the start and turn it back on at the end, plus turn off the "setwarnings" at the start and turn it back on at the end too. This way your screen won't jump around while the macro is running and you won't get the on-screen prompts with the update query.
HTH, Andrew.
