Print Specific

[Kirstie Adam]

Dear All,

I have a report which prints every contact in my database. It is done from a
straightforward query. However, each contact has a field for which regional
office of our company they are connected to. This field is a combo box,
listing each office.
I want to be able to print a report for every client for one of our offices
(eg. All clients connected to our London office)
What's the best way to do this?

TIA

Kirstie

 

[tom]

Place the regional office name in the Criteria field for that column in the
query.

Tom.

 

[Kirstie Adam]

Is there a way of doing it via a pop-up form which has a combo box on it,
listing the choices?
I want to avoid having the users trping the office names in each time.

Kirstie

 

[tom]

Yes... instead of calling your report, call a new form with an unbound combo
on it listing all your clients. When the user chooses a client and presses a
print button, call your report that has a criteria in it's RecordSource
(client field) pointed directly to the combobox value.

HTH.

Tom.