Criteria for query

  • Thread starter uday kulkarni via AccessMonster.com
  • 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?
 
N

Nikos Yannacopoulos

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
 

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
Use In() Expression as Query criteria with guts from Function 1
ignor criteria if null? 4
Access Dcount (multiple criteria) 3
Using a textbox as a criteria for a query 1
Query criteria problem 2
iif in the criteria 3
Selected record as query criteria 2

Top