Drop Down Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, here is what I want to do. I have about 15 different models of computers
where I work. I made a query for each model to grab all the records that
have that model of computer in them and put it into a report. Contained in
my form are 15 buttons that when clicked will launch the form corresponding
to the model that is its label. That all works great. But here is the
problem. I have about 35 different models of printers I want to do the same
thing, but I don't want a mess of command buttons in my form. I would rather
have a drop down box that contains all the models of the epuipment and when I
make a selection, it then opens up the report. Is this possible and how hard
is it?
 
Guiliano

Are you saying you could create a "lookup" table that holds all of the
different models, one per row?

If so, you could create a form that had a combo box on it, said combo box
using either the lookup table or a query against it as a source.

Then you'd add a command button that opens the report. The report would be
based on a query that had a parameter under the "model" field in design
mode. That parameter would "point" at the form's combo box for its value --
something like:

Forms!YourFormName!YourComboBoxName

Note that you could do the same for your computer models, too. You could
throw out all the extra queries and reports and use one for computers, one
for printers (unless you capture the same info for both, then you could use
one!).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thats what I was looking for. I will try this next week when I am back at
work. Hopefully with my lack of training, I can get this to work. I am
quite amazed with what I have done so far so hopefully I can do this too.
Thanks.
 
Back
Top