load and next buttons

[landog]

I have a "load" button whose event opens a database connection, populates a recordset with a database query and loads the first record into various textboxes.



I would like a "next" button to get subsequent records.

But the recordset from the load button is not in scope of the subroutine associated with the event code of the "next" button.

How best to get the two subroutines to operate on the same set of data?

How would each selection of the "next" button know where the previous one had left off?


Thanks,
-dog

[June7]

Why are you using unbound form and code to populate form?

Try:
Declare a public recordset variable in module header. Set the variable in the 'load' button code.

[landog]

6-7: Thank you!