Pulling Client names from existing table to a pulldown on report prompt

[Jason]

I have a table of past jobs my company has worked on. A
feidl in this table is "client name". I have a
switchboard setup with some reports on it. One of the
reports is pulling all jobs by a paticular client. I want
a way to add a pull down list of client names to this
report so that you don't have to type in the name. So
lets say I have 500 jobs and 50 clients, so there needs
to be a pulldown with the 50 clients on it.

Thanks!

 

[Ernie]

Create a query such that you can get a list of these
clients. Make it a 'totals query' so that you can use
the "group by" to get unique names. Then add an unbound
combo box to the form and in its "Row Source" put that
query name.

Alternatively, add an SQL statement to take the place of
the query as above in the Row Source of this unbound combo
box. With an SQL statement you can use the "UNIQUE"
identifier instead of making a totals query.
Example:

SELECT UNIQUE ClientName FROM OldJobsTable WHERE...

or

SELECT TOP 1 ClientName FROM OldJobsTable WHERE ...

HTH