Combo box vs. Query

  • Thread starter Thread starter Robert Ross
  • Start date Start date
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!
 
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?
Click to expand...

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.
 
Back
Top