In a similar case I used the tab control.
The forms can be placed as subforms and the tabs can be controlled like:
me.tabCTL.pages("first").visible = false
me.tabCTL.pages("second").visible = true
etc. with the pagename or relative like:
me.tabCTL.pages(1).visible = false
me.tabCTL.pages(2).visible = true
etc.
Idea ?
Nic;o)
Forgive me in advance if I complicate this. It's a good idea, but because I didn't disclose more details, it may not work. My apologies.
Forms are set up so that Form A also has Subform A1 attached (linked through an ID field). Subfrom A1 then becomes Main Form B on the next form. Main Form B has Subform B1 attached (linked through ID field). Subform B1 then becomes Main Form C on the next form. And so on.
As I move from "Main Form B/Subform B1" to Main Form C, How can I load Main Form C with the last record I used in Subform B1?
Otherwise, Main Form C load with the first record on file and I have to scroll to find the newest record I added. I hope this makes sense, and again my apologies.