List Box On Form

  • Thread starter Thread starter John Scanlon
  • Start date Start date
J

John Scanlon

I have created a form which I use to provide parameters for queries and
reports. Upon opening the form three list boxes to provide lists of options
for various queries which can be run. Upon opening the form the queries
behind these list boxes run and populate the queries. What I need to do is
have some other actions on the form refresh these queries. For example, one
of the list boxes builds a list of employees which can be selected to report
against. Also on the form are several check bxes whcih indicate departments
within the company. So, if I have department check boxes for departments
"A" thru "F", and I select check boxes "B", "C", and "E", the list box query
should only show me employees from those departments. If I then select
department "A" selecting it's check box, the employee list box query should
update the available employees in the list.

Any idea how to accomplish this????
 
Hi John

if you'ld like to email me (julied_ng at hcts dot net dot au) direct i'll
send you a mini database with an example of how to do this in it

Cheers
JulieD
 
Back
Top