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 - 17 Mar 2008 19:20 GMT
<snip>
> 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.
--
Clif