I want to restrict users to only a form view when opening a database. There are several forms that the user may use. I can't figure out the VBA I should use to allow the user to choose a form name from the 'Select_Form' form and then open the form they selected. I've tried 'After Update' event and I can get the name of the form selected, but I can't pass that selection to a module that would open that form.
In my 'After Update' code, I have:
which displays the form selected.
In my module, I have:
The last line 'Msgbox' gives an error 'null' value
Would appreciate any help.
Thanks.
In my 'After Update' code, I have:
Code:
MsgBox Forms!Form_SelectF!Form_Name
In my module, I have:
Code:
DoCmd.RunMacro ("Open_Form_SelectF")
MsgBox Forms!Form_SelectF!Form_Name
Would appreciate any help.
Thanks.