Query Criteria from a SubForm

S

Sorlenny

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.
 
R

Rubianob

Sorlenny,
Tab control has no impact on the syntax. You sould use:

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

Regard,
 
Top