I have an ADO connection to a database.
I define a query and open a recordset using that connection.
I set the datasource for a datagrid to the recordset (in the program, so it is unbound).
The datagrid is populated and the user can scroll through the records: all of that works great.

Here is where I am stuck:
I do not want the user to make any edits to the database directly in the datagrid, but I do want the user to be able to flag currently selected record(s) in the database. So, I have a command button that I want to use to update one field in the database called "flag" (set it to a value of 1), for the currently selected record(s) in the datagrid.

What do I put in the click event of the command button?

Rick