Hello all,
I am building a new database, and want the end-user to only be presented with forms, and navigate between them using buttons or similar tools.
On the 'Home' form, I want the user to choose an option from Category A and another in Category B, then hit a button which will open a form based on those choices.
For example, in Category A, the user can choose 'Bike' or 'Car'. In Category B, the user can choose 'Red', 'Blue', or 'Silver'.
When the user clicks a 'Go' button, I want 1 of 6 forms to open based on their selection. (About a red car, or a silver bike, etc, etc...). How do I do this?
The categories are set up as Option/Radio Buttons, but don't have to remain so.
As I want this database to be usable (and fixable!) by multiple people, I would prefer to avoid using macros or VBA to do this. These tend to harder to diagnose and fix when they fall over; and the target audience for this db is not particularly familiar with these techniques. (The end users are engineers, but all have limited or no experience with Microsoft Access).
Thanks in advance,
Tom
I am building a new database, and want the end-user to only be presented with forms, and navigate between them using buttons or similar tools.
On the 'Home' form, I want the user to choose an option from Category A and another in Category B, then hit a button which will open a form based on those choices.
For example, in Category A, the user can choose 'Bike' or 'Car'. In Category B, the user can choose 'Red', 'Blue', or 'Silver'.
When the user clicks a 'Go' button, I want 1 of 6 forms to open based on their selection. (About a red car, or a silver bike, etc, etc...). How do I do this?
The categories are set up as Option/Radio Buttons, but don't have to remain so.
As I want this database to be usable (and fixable!) by multiple people, I would prefer to avoid using macros or VBA to do this. These tend to harder to diagnose and fix when they fall over; and the target audience for this db is not particularly familiar with these techniques. (The end users are engineers, but all have limited or no experience with Microsoft Access).
Thanks in advance,
Tom