Using a variable in a control reference

[Guest]

Hope I got that title right.

I use one form with command buttons to pass the name of a third form to be
used as the openargs of the second, intermediary form. If that does not make
sense -
I have a form name in openargs. I then use a variable STDOCNAME =
me.openargs to refer to that form name throughout code. When I finally open
that form, I want to turn on the navigation buttons. However, this does not
appear to work:

stDocName = Me.OpenArgs
DoCmd.OpenForm stDocName, acNormal, , sfilt
MsgBox ("Please use the navigation buttons, not the drop down boxes, to
move between records")
Forms!stDocName.NavigationButtons = True

What should this look like?

 

[Rick Brandt]

Hope I got that title right.

I use one form with command buttons to pass the name of a third form
to be used as the openargs of the second, intermediary form. If that
does not make sense -
I have a form name in openargs. I then use a variable STDOCNAME =
me.openargs to refer to that form name throughout code. When I
finally open that form, I want to turn on the navigation buttons.
However, this does not appear to work:

stDocName = Me.OpenArgs
DoCmd.OpenForm stDocName, acNormal, , sfilt
MsgBox ("Please use the navigation buttons, not the drop down
boxes, to move between records")
Forms!stDocName.NavigationButtons = True

What should this look like?

Forms(stDocName).NavigationButtons = True

 

[Guest]

Works just right, thanks.