Hello Folks,

This may be a really simple thing, but I haven't found the answer.
Perhaps you'll tell me my approach is all wrong. Either way, I am
stumped and need some help, please.

I have multiple, similar 'dashboard' type forms that call code, open
other forms, etc.

I have a process in which a secondary form is opened by actions on the
dashboard, and then, depending upon choices made on that secondary
form, code may be called to make changes to a table and then the form
that originally started the process. I have been storing the dashboard
form name in a hidden field on the secondary form, how can I use that
String version of the name to open a form object in code that will
refer to the original form?

Thanks

Assuming you have the name of the form in a textbox named txt1, you can
refer to the still open form in the background like this:
Dim frm As Form
Set frm = Forms(Me.txt1.Value)

Or you can make it the current form with:
Forms(Me.txt1.Value).SetFocus

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave" <dahaskins (AT) gmail (DOT) com> wrote

Thanks Allen!

I knew it would be a simple answer, but it was eluding me nonetheless.

I've already plugged that into my code with success.