Is Me.Parent possible in a Select statement?

[Peter Stone]

Novice/Access 2003

I have a Select statement on a list box. The criteria for one column is
[Forms]![frmText]![cboDestination]

Is there any way I can replace [Forms]![frmText] with Me.Parent. I am going
to duplicate and rename the form and it will save changing the reference
every time I do so.

Thank you

Peter

 

[John Vinson]

Novice/Access 2003

I have a Select statement on a list box. The criteria for one column is
[Forms]![frmText]![cboDestination]

Is there any way I can replace [Forms]![frmText] with Me.Parent. I am going
to duplicate and rename the form and it will save changing the reference
every time I do so.

Thank you

Peter

Only by creating the SQL for the query in code. The JET query engine
knows nothing about form properties such as Parent.

John W. Vinson[MVP]