how to make a criteria regarding a subform

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi.

How can I make a criteria in a query to get the value from a subreport field?

Regards,
Marco
 
[Forms]![FormName]![SubformControlName].Form![ControlName]

Note: SubformControlName is the name of the subform control on your main
form. NOT the name of the form being used as a subform.
 
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

Query to count records in a table 2
Access Dcount (multiple criteria) 3
Criteria using values from a table 1
Criteria is not working 3
Criteria to search any part of the field 1
Need help getting query to reference a field in a subform 2
how make a select with a AND in columns 1
Parameter Value error in a Subform 0

Back
Top