Macros, VBA, etc disabled. How to call 1 of 19 subforms from a main form combo box?

[jdusn1978]

What is the best way for the main form combo box to bring up the correct sub-form of the 19 available?

The main form has a combo box called [cboCategory] which has the options of selecting Category 1-19. When creating a new record, the data entry user selects, let’s say, Category 3 from the combo box. I’d like the sub-form for Category 3 to appear in order for the user to finish the data entry. I’ve thought about a filtered “Next” button which leads to the correct sub-form. But this is ugly; it would be nice as a sub-form.

All 19 forms are identical. The only difference is the category and how that affects the IIf statement text of the associated checkboxes. I cannot combine all of this into one table, it has too many columns. Macros, Functions, VBA etc disabled on my network and will not be enabled. I cannot use most of the awesome suggestions I’ve received from this page. Things that should be simple and combined through code must be separated and complicated.

I had two tables, but now I have to turn one of the tables and it’s sub-form into 19 different tables and 19 different sub-forms because now I cannot write a private function to interpret the data that is input as needed, I now have to create 19 different IIf statements. One IIf statement is two large unless I could daisy chain queries. Which I do not know how to do either.

[zmbd]

Ouch. We can get into the politics as to why your IT disabled both Access Macros and VBA - and it's a red-herring as far as network security is concerned (good antivirus and anti-malware programs are more effective); however, it's their problem that they've crippled several hundreds of dollars of software and cost themselves even more in labor.

You may still have some minimal Macro control. If so, then we may have a few options:
+ Use the minimal "Safe" subset of macro actions to set and alter your form's subcontainer properties.
+ Use a tabbed form for all of your category forms
+ Use a form-navigation-control

I've attached a small database that will check to see what is going on, what I need you to do is to d/l ZIPed database, scan for virus using your company's anti-virus, either extract the database first or open the database from the zipped file (extracting first will make things much clearer from a "system messaging" point of view),

++ IF you have only one button click on it - the application should close and you're done. Report back here what happened - number of buttons and colour

++ IF you have two buttons, click on the first one. As above the application should quit. Re-Open the file, once you're to the final form, click on the second one. The application should quit.

++ You're more than welcome to inspect the macro and vba scripts before doing any clicking. The first button has an embedded macro that you can only see by opening form.f_splash in design mode, and showing the properties. The macro for the second control is the same... both just quit Access. The autoexec macro checks for trusted state and executes either macro actions within the same macro or the function found in the standard module.

When you open the database:
+ there should be two messages boxes that pop open.
+ You will see a form loaded in the background.
+ The form will either update and show zero, one, or two command buttons after you have clicked thru the two message boxes and the text will update to reflect what is going on.

Once we have a clearer picture as to what we have to work with we can dive into the deep-end

We may also discover that you might be able to do more than you think and can simplify a great deal of your database design!

-Z