List box pull up selection in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
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???
 
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
 
Back
Top