Is Me.Parent possible in a Select statement?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
Back
Top