Combox in criterium in query?

message from Henro on 29 May 2004
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
 
Luiz Cláudio replied to Henro on 29 May 2004
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

"Henro" <maxlesallaud@hotmail.com> escreveu na mensagem
news:OTLVkQYREHA.2216@TK2MSFTNGP12.phx.gbl...
 

Archived message: Combox in criterium in query? (MS Access Database)