Combo and List Box Combination

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Newbie Nanette here again,

I have a combo box that looks up a RF number from a table. This combo box is
connected to an extended multi select list box that displays all the rows
applicable to the specific RF number (data is pulled from the same table).
This works great.

What I need to do is have the multiple selections of these two boxes appear
in a subform. I believe I need to create a record source for the subform,
perhaps based on a filter?

My selection could look like:

RF #1a, Charge # 00, Line Item 00111
RF #1a, Charge # 01, Line Item 00222
RF #1a, Charge # 01, Line Item 00333

The RF # would always be the same. The charge and Line Item #s will be
different.

HELP! :-))
 
I came up with a better solution.

I set my list box to be updated by my combo box so that the appropriate
items are displayed in the list box. (I hid a column so that all the fields
needed are in the list box).

I will set up the multi select list box to fill in a sub form.
 
Back
Top