Hello. I have been working on this for a while, and I have finally gotten to a point where I THINK that I finally know what to ask.
I think that what I am trying to do is to create my own menu system instead of using the "Switchboard" option in Access.
You see, I have a form named "View Reports". In its operational view it looks like this:
…and, in its ‘design view’ view, looks like this:
(basically, a title/header, an “unbound” object and 2 buttons)
The “Form” itself uses a query as its control source. The query looks like this:
(pretty basic)
And here is where I am stuck. What I am trying to make happen is this:· If you select the first option, “View Filter Types”, and then click on the “Open Report” button, it will open a similar form that lists the filter types (ie. “Oil Filters”, “Air Filters”, Fuel Filters”, etc.).
· If you select the second option, “View Batteries Used”, and then click on the “Open Report” button, it will open the actual report “Batteries Used”.
· If you select the third option, “View Belt Types”, and then click on the “Open Report” button, it will open a similar form that lists the belt types (ie. “Fan Belt”, “PTO Belt”, Deck Belt”, etc.).
· If you select the second option, “View Tire Sizes Used”, and then click on the “Open Report” button, it will open the actual report “Tire Sizes Used”.
· If you select the second option, “View Spark Plugs Used”, and then click on the “Open Report” button, it will open the actual report “Spark Plugs Used”.
In short, what I am trying to do is to create a form where its contents can be executed to either open a form or a report... respectively. So if you select the "View Filter Types" line, it will open a form. While, on the other hand, if you select the "View Batteries Used" line, it will open a report.
Any ideas???
Thx!
DG