Query linked to a combo box

[Argonaught]

i have tried to link the combo box to exsisting queries but i get an error message when using the wizzard that says "No value given for one or more required parameters.

the query used is to look up author names, its criteria is:

Like [Books1]![Author] & "*"

Any ideas?

Cheers
Argonaught

 

[namliam]

What is books1??? I am guessing a form?

Then you need Forms![Books1]

BR

 

[Argonaught]

[books1] is my table containing my [authors] field.

Cheers
Argonaught

 

[Graham T]

Argonaught

You could try the following example:

Filtering the results of a Microsoft Access query using a Drop-Down combo box

HTH

Graham