how to select record that you want to print in query criteria

[Marco]

Hi. I need to build a form the has some options to make wich will after the
filter/criteria for queries.

my olnly question is that I have to build something that will allow me to
from a list of deprtments wich one I want to print.

I have a table with all departments. Now I wanted to have a list or grade on
my form that would allow me to choose two department of 10.

I start to create a subform in continuous form with all results from the
department table. then I insert a check box in the detail option but any time
ti choose a department by clicking the check box all departments were
selected.

I can I solve this? How can I have the possibility choosing what departments
I want to select?

Regards,
Marco

 

[Clif McIrvin]

I can I solve this? How can I have the possibility choosing what departments
I want to select?

Can you use a combo box instead of sub-form? I use combo-boxes
frequently to select one member of a group from one of my tables.

Add an unbound Combo Box to your form and set the row source to a
query that generates the list of choices for you.

Using this method requires code to manipulate the filters.