Looking up Names in a Query

[CKelly55]

I have created a Database for my Camera Club, I am now trying to make a query to Search a list of Competitions and return the entries against the Photographers name. I have done this but have to type in the Photographers name, what I want to do is to be able to Look Up a list of Names for the Photographers. The table I have for the Photographers is - "Photographers" and the field I need to look up is "Name". Can anybody help me please.

[burrina]

You have some naming convention issues.
tblPhotographers
Photographer

Name is a reserved word in Access.
All of that said, you can either use a parameter in your query; Example: [Name of Photographer Please]
Or simple add Only the required fields in your query, i.e. "Photographer" and sort as you wish.
What data type is Competitions? Enter your criteria under this field for filtered results.

HTH

[CKelly55]

Thanks, I think I understand. Does this mean I should change my Field Title in my Photographers Table to something like 'Photographer'. The Photographers table is just a list with Names,addresses, telephone numbers and email addresses on it in the form of a table.

[burrina]

Here is just on example: http://en.wikipedia.org/wiki/Leszyns...ing_convention

HTH

[CKelly55]

Here is just on example: http://en.wikipedia.org/wiki/Leszyns...ing_convention

HTH

The problem I am having is with the syntax. I have built a query that returns the results I want but using the Search Command. This opens a dialogue box and I have to type in the name of the Photographer. I really want to simplify things by having a drop down list of Photographers when I start my query. I have tried DLookup and Select but can't get the syntax right.
tblPhotographers
Photographer

The Competitions Table is just a list of Competition Titles, Scores and Format.
tblCompetitions
Photographer.Title.Competition.Format.Score.

[burrina]

Your not going to be able to do this with a query based dialogue box. Why not simply use a combo box on a form?

[CKelly55]

Your not going to be able to do this with a query based dialogue box. Why not simply use a combo box on a form?

Ok, thanks for the information. Not sure how to use a combo box, I'll have to do some reading up. This Forum has been really helpful.