G
Guest
To facilitate navigating the database, I hide and unhide certain main forms
and I needed a way to "remember" which form I came from so I can unhide it
when I am done with my little side trip. To remember how I got there, I have
set up public variables (strings) called TargetForm and ReturnForm so that
when I close a form it returns or makes visible the one I came from. However,
I am having trouble with the syntax when calling a variable within a form
command as shown below. Remember, I can't use Me.Visible, because I am
closing the current form, which is where this code is, and returning to the
original one, and this command is needed to make the original one visible
again.
Forms![ReturnForm].Visible = True
Access tells me it can't find the form ReturnForm, yet in the if statement
surrounding this, the mouse over value is there. Thanks for your help.
and I needed a way to "remember" which form I came from so I can unhide it
when I am done with my little side trip. To remember how I got there, I have
set up public variables (strings) called TargetForm and ReturnForm so that
when I close a form it returns or makes visible the one I came from. However,
I am having trouble with the syntax when calling a variable within a form
command as shown below. Remember, I can't use Me.Visible, because I am
closing the current form, which is where this code is, and returning to the
original one, and this command is needed to make the original one visible
again.
Forms![ReturnForm].Visible = True
Access tells me it can't find the form ReturnForm, yet in the if statement
surrounding this, the mouse over value is there. Thanks for your help.