Moving forms RecordSelector to next record in Code

[KatGraham]

I have a table (tblQueries) setup as follows:

ID (autonumber query run order)
txtQueryName (name of query to be run)
chkCompleted (yes/no)

There is a command button on the Mainform that call a function.

The fuction opens a subform (that is tied to tblQueries). The subform is Continuous and a popup.

I then have used a Recordset that updates the chkCompleted box on the table.

I also want to have the forms Record Selector move alone with the active query that is being run.

HOW?

 

[JackOfAllSoftware]

I think the command you are looking for is:

DoCmd.RunCommand acCmdSelectRecord


Just make sure that you are &quot;on&quot; the record you want to select... Since you are setting a checkbox, I assume that you are already doing this, but if not, you may need to do a me.recordsetclone.findfirst <<criteria>>, then set your me.bookmark=me.recordsetclone.bookmark

Steve