I have a db that will create several instances of a form. I would like to refer to a field on a specific instance of the form for a query criteria. I have tried:

forms![frmEmpInfo(1)]![SSN]

This didn't work. Any ideas? Thanks in advance.

Eric

If I am correct that you want to display on a form a control's value on another open form, add brackets around the "form" as in :

=[forms]![frmEmpInfo(1)]![SSN]

HTH