Print Specific

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

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
 
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
 
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.
 
Back
Top