Making a recordset 'active', or the 'current' recordset

[charlie1111]

I have several different recordsets that populate listboxes, and are 'public' and therefore seem to persistent between various forms and subforms.

When a user clicks a button on the form, I need to goto a specific record in one of those recordsets to repopulate the listbox. I can't seem to figure out how to make that recordset current, so I can go to that specific record.

I've tried work-arounds, e.g., by opening the table and using 'DoCmd.GoToRecord' but then the table opens in datasheet view before going to that record. (But why reopen the table if the recordset already exists).

Ideas on how to do this?

Thanks for the help.
Charlie

 

[Remou]

I can quite get what you are saying. You can requery listboxes to refresh the data and you can select items. Do you mean a subform? You can go to records in subforms. What do you wish to do?

 

[charlie1111]

Sorry - right after I posted I realized the error of my ways.

Thanks tho,
Charlie