Custom Menu Form vs. Navigation Form

[Oimoi]

I'm nearly done with my database and just now starting to mess around with a tab-based navigation form. Huzzah!

But, unfortunately, I'm having to go back and tweak a lot of the "links" and query criteria. For example, a criteria that used to reference the value in one form's combo box NOW has to reference the value from the same form but from the navigation form. Otherwise, [Forms]![FormName]![ComboBox1] becomes [Forms]![NavigationForm]![NavigationSubform].[Form].[ComboBox1].

In the long run, would it be worth it to make all of these adjustments? Or would a custom menu form with command buttons work just as well? (Wasn't a whole lot of planning ahead on my part. )

---

Many thanks to anyone who reads this!

 

[Uncle Gizmo]

My preference is the "Switchboard" provided by Microsoft Access.

It takes a lot of flak from some programmers, and indeed the interface which controls it is terrible!

But the rest of it, particularly if you use an older version of MS Access to create it, a version that creates a VBA backend, then it's a wonderful piece of code that you can hack in various ways.

The code itself is a very clever piece of engineering, well worth studying, you can learn a lot from it.

 

[Galaxiom]

I don't like the Switchboard. It is basically a crippled form because the RecordSource has been taken over by the information about the object in the database. I will admit it is pretty clever bit of engineering.

However it doesn't really do anything that can't be done with a fully functioning form.

I have a function that creates a form with a set of buttons to open any object in the database. That form is easily modified and still has the ability to use the RecordSource.

 

[Oimoi]

Using Access 2010, my first and only experience with the system.

I was actually a bit pressed for time, so I went ahead and started my own menu form. For now, I'm just making buttons and fiddling with their corresponding macros. But I do plan to explore this "Switchboard Manager" when I have more time (and no looming deadline)! Thanks very much for the input. =)