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???
 
Ad

Advertisements

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

Top