pointing queries to a field on a form

  • Thread starter Thread starter Guest
  • Start date Start date
You reference a control on a form by using the following syntax. The form
must be open for this to work.

[Forms]![Your Form Name]![Your Control Name]

Make sure you reference the Control's name and not the Field's name. They
can be the same, but they can also be different.
 
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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
result query on a form 1
Split data in field on character return 0
How To Specify No Criteria 2
use field list from form to specify query fields 2
Parameterizing in a Cross Tab Query 2
Query driven by form field 1
Query results based on fields in a form. 2

Back
Top