Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rorm recordsets not opening

Status
Not open for further replies.

grgimpy

Programmer
Nov 1, 2006
124
US
I have a main form with a tab control and multiple pages. On each page is another form. On each form of each page I have "add record", "previous record", and "next record" command buttons. When I open up the main form containing all these different pages, a couple of the pages to not load the recordsets. I cannot go to the previous record and get a "no current record" message box. If I add a record, then try using the "previous record" command button, it works fine. If I open up the form by itself, everything works fine.

I've tried using different Form.Recordset.Move commands to see if I can get the form to open up on a different record (right now it opens on a new record, which is what I want), but still get the "no current record" message box. Again, if I open this form on its own, everything is fine. If I open it up simultaneously with the other forms under my main form, it will not go to the previous record.

Any comments to point me in the right direction would be appreciated. Thanks!

 
Are you buttons on the main form or the sub form? I know sometimes I put buttons on a tab and they are not always on the subform or even on a particular page.

ProDev, MS Access Applications
Visit me at ==>
May God bless you beyond your imagination!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top