From: Jack Leach dymondjack at hot mail dot on
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

"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
Thanks for the help, I'm away for about ten hours. Will test and reply back.