Combox in criterium in query?

H

Henro

I have a query with a field called [Engineername] based on the table
[RegHours]

I have as a criterium on the field [EngineerName]: [Which name?]
As a result on opening the query it asks for the name of the engineer.

The user though has to type in the full (correct) name of the wanted
engineer.
Is there a way to make a combobox that lists all the names in the table
Engineer in the field [Engineername] ?

TIA Henro
 
L

Luiz Cláudio

Hi Henro,

you can create a form with a combo, and then set the criterium as

Forms!YourForm!YourCombo

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 

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

I have a table containing 8
Criteria in query's 4
GotoRecord? 2
Value from form as criterium in query? 2
Need Help... 5
Find last value after a certain date? 1
third page on form only showing one series of records 2
Query Parameter using multiple options 0

Top