Prev: Command Button to open a password protected excel spreadsheet
Next: Zooming in on a picture on a form
From: Jack Leach dymondjack at hot mail dot on 23 Feb 2010 12:14
Another way would be to store the ActiveForm.Name in a variable and call it
through the Forms collection...

Dim sForm As String
sForm = Screen.ActiveForm.Name
Debug.Print Forms(sForm).Controls(fsubTxt1).Form.Controls(txtPub).Value


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Peter Stone" wrote:

> Thank you
>
> Just what I needed.
>
> Can I pass a reference to the control like this?
>
> Screen.ActiveForm.Name!fsubTxt1.Form!txtPub
From: Peter Stone on 23 Feb 2010 14:20
Thanks for the help, I'm away for about ten hours. Will test and reply back.
First  |  Prev  | 
Pages: 1 2
Prev: Command Button to open a password protected excel spreadsheet
Next: Zooming in on a picture on a form