List box pull up selection in combo box



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)
After selecting (on AfterUpdate) "Visa" in the combo, requery the
listbox, and will only show records with "Visa" in the CardType field.
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