Criteria for query

  • Thread starter Thread starter uday kulkarni via AccessMonster.com
  • Start date Start date
U

uday kulkarni via AccessMonster.com

Hii.. everybody
I want to use comboboxes on a form, which are referenced in the
criteria section of the query, so that the query returns record for the
selected value in combobox.How this reference can be set?
 
Assuming the form is named MyForm, and a combo on it is named MyCombo1,l
you can use the following as a criterion in a query:

Forms![MyForm]![MyCombo1]

HTH,
Nikos
 
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

Cao Thanh Trung - THK26 1
All-Record criteria in a query...hmmm 4
Access Dcount (multiple criteria) 3
Combobox for criteria help 5
Use In() Expression as Query criteria with guts from Function 1
Query Parameter using multiple options 0
Query criteria problem 2
If statement that returns all entries or one 2

Back
Top