Query Criteria from a SubForm

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

Guest

Hi,
I have a query that get the criteria from a SubForm in a Tab Control
belonging to the Main Form. I am using the expresion:

[Forms]![MainForm_name]![PageName].[Forms]![SubForm_Name]![Controlbox]

When I run the query with the subform alone open it works fine, but when I
try to run the query with the Main Form open , I got asked to enter the
parameters manually.

I tried already entering the criteria fields in the Query Parameters but
still it did not work.

Please any help will be very appreciated.
 
Sorlenny,
Tab control has no impact on the syntax. You sould use:

[Forms]![MainForm_name]![SubForm_Name].Form![Controlbox]

Regard,
 
Back
Top