Combo box vs. Query

R

Robert Ross

Ok, I've asked this question a bunch of times and no-one
seems to know the answer, so I'm hoping some of the
brilliant readers out there can help me out.

I need to make a form that contains a Combo Box. This
combo box will populate from a query based on the
supervisor's ID that is logged in.

I need to be able to have the users selected by the
supervisor be the criteria for a query. In other words,
if Supervisor 1 logs into the database, I need only their
employees to appear in the Combo Box (not a problem - I've
done this part). I then need the Supervisor to be able to
select one or more of their employees in the Combo Box and
have a query call to the Combo Box to determine what
records to display. I REALLY do not want to do this using
anything other than the QBE grid...my company freaks if I
use VB or SQL.

If this can't be done in a Combo Box, does someone know
some other way to make this happen?

THX!
 
R

Rick Brandt

Robert Ross said:
Ok, I've asked this question a bunch of times and no-one
seems to know the answer, so I'm hoping some of the
brilliant readers out there can help me out.

I need to make a form that contains a Combo Box. This
combo box will populate from a query based on the
supervisor's ID that is logged in.

I need to be able to have the users selected by the
supervisor be the criteria for a query. In other words,
if Supervisor 1 logs into the database, I need only their
employees to appear in the Combo Box (not a problem - I've
done this part). I then need the Supervisor to be able to
select one or more of their employees in the Combo Box and
have a query call to the Combo Box to determine what
records to display. I REALLY do not want to do this using
anything other than the QBE grid...my company freaks if I
use VB or SQL.

If this can't be done in a Combo Box, does someone know
some other way to make this happen?

Well you have a few problems here. A ComboBox does not allow multiple
selections. A ListBox can be set up to allow multiple selections but those
selections can only be evaluated using VBA code.

You could have a work table that the supervisor populates with a continuous form
(using a ComboBox) and then use the work table in the query that displays the
other records. You would then clear the temp table when finished.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top