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 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! )