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?
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?