combo boxes

[bbutterf]

I have a need to be able to use 2 combo lost boxes to
select data from a table. How can I accomplish this feat


thanks
bruce

 

[GDub]

-----Original Message-----
I have a need to be able to use 2 combo lost boxes to
select data from a table. How can I accomplish this feat


thanks
bruce
.
Hi Bruce, Did you mean Combo LIST Boxes? You'll need to

have your Toolbox icons visible in your Form's design
view.
Depress the Combo Box button on the Toolbox (located to
the right of your checkbox on the Toolbox toolbar)

Bring your mouse cursor to the desired spot on your form
and left-click to deposit the Combo Box. When the wizard
opens, press "Next", then select the table or query you
desire and the field(s) that contain your data. The
wizard should walk you through the rest.

Geoff

 

[John Vinson]

I have a need to be able to use 2 combo lost boxes to
select data from a table. How can I accomplish this feat


thanks
bruce

You can use a form reference (to an *UNBOUND* combo box, i.e. a blank
Control Source) as a query criterion: just put

=[Forms]![NameOfYourForm]![NameOfTheCombo]

on the criteria line of a query. If you have two combos used to search
two fields, just put them both on the query criteria line.

It's convenient to base a Form (for display) or Report (for printing)
on the query, and put a button on the form with the combos to open
said form or report.