Navigating Around Forms

[BayEnder111]

Hi Guys,

This is probably going to be a stupid thread but it's driving me insane now.

I have 5 forms in my application and I'm just trying to navigate around them using buttons to go from Main Menu to the next form etc.

My first move is when the Button "cmdreports" is clicked on the frmMain form it opens frmReports.

In VBA on the Form frmMain I've inserted:

Please Login or Register  to view this content.

However when I run this I get the "Run Time Error 424: Object Required".

I don't need to declare all my Userforms do I? I was under the impression I didn't as there objects within Access anyway.

Any help would be greatly appreciated.

[mikerickson]

It might be easier if instead of 5 user forms, you used one user form with a 5 page multipage control.

[sktneer]

Make sure that the name of user form in its properties is set to frmReports.

[Norie]

Is this Access or Excel?

[BayEnder111]

Make sure that the name of user form in its properties is set to frmReports.

Yeah I've tried all the naming conventions to make sure they're correct.

Is this Access or Excel?

It's Access 2010.

[Norie]

You don't use Show to open forms in Access, you use DoCmd.OpenForm.

Please Login or Register  to view this content.

[BayEnder111]

You don't use Show to open forms in Access, you use DoCmd.OpenForm.

Please Login or Register  to view this content.

Thanks very much - Turns out using an Excel 2010 With VBA book to learn wasn't such a good idea!

I assumed the functions would be the same.