How do I reference "Forms![frmMain]![frmRecID]![frmRecTransEntry]"? 1

[JennyPeters]

Instead of typing "Forms![frmMain]![frmRecID]![frmRecTransEntry]" in reference to a form that I have over again in different procedures, how can I reference this with a variable, so I could then do:

variable.requery

Thanks,

Jenny

 

[hilbertl]

Jenny,

You can use the form object
Take a look at this example:

Dim test As Form
Set test = Forms!Forms![frmMain]![frmRecID]![frmRecTransEntry]
test.Requery

Hilbert

 

[LonnieJohnson]

Nice one Hilbert.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[hilbertl]

Thank you.

H.