lnbarnes
01-03-2002, 10:59 AM
Ok, will try to explain this a little better than previous message. I have a query that I want to run from a form and it is supposed to take the Project Name from an unbound list box on the form. This unbound box gets its information from the Projects table. The Projects table has as its fields, Project Name, All (boolean), Scope (boolean), Scope 2 (boolean), DEIS (boolean), and FEIS (boolean). On the form where the unbound list box is, I have boolean controls that correspond to the boolean fields in the table. The boolean fields on the form are merely controls for selection and are not linked to the underlying table. What I want is for the user to select the Project Name from the unbound list box and select one of the boolean controls on the form. This will bring back all of the people that wish to have a particular report (boolean controls). I hope I have been clear on what I want to achieve. I am relatively new to Access, so bear with me.