List box pull up selection in combo box

G

Guest

I have a list box for a finance program that shows all records and pertinent
information. I want the form to pull up only those records in the list box
that are being selected in the combo box. For example I have several records
tied to "MasterCard." When the combo box pulls down to "MasterCard" I want
the list box (once refreshed) to show only the items that are MasterCard
items. Can this be done???
 
A

AlCamp

Sure... in the query behind your listbox include the (ex. ) CardType
field, and for a criteria on the column...
(use your own names)
=Forms!frmMyForm!cboMyCardType
After selecting (on AfterUpdate) "Visa" in the combo, requery the
listbox, and will only show records with "Visa" in the CardType field.
hth
Al Camp
 

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

Similar Threads

Combo box / Query 1
Combo Box Selection 2
Need to pull a list of data from a Combo Box Option 1
combo box selection to auto fill a second combo box (or field) 1
List box selection into combo box 2
combo box selection 2
Combo box - not in list 2
Combo Box Display 3

Top