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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
I have a table containing 8
Need Help... 5
Criteria in query's 3
QBF & Query Malfunction 0
ASK Field Formatting 1
mergemail query 0
Showing combo box box that's not an option in its drop-down list 5

Top