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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Do not run subform criteria when form opens 1
Parameter Value error in a Subform 0
Using an append query in a subform 1
filter query on combo box in a continuous subform 0
Data from a subform into a query 2
VBA Syntax for subform record source change 6
Still stuck: rerunning a query to change criteria 1

Back
Top