S
Scott J.
I am creating a form basically to replicate a report of all parts ordered by
each supplier. (I need it in a report so it can be interactive, open specific
forms for each part, etc.)
Example:
Supplier A
- Part 1
- Part 2
- Part 3
Supplier B
- Part 1
- Part 2
....etc.
My idea is to use a continuous form with a textbox to hold the supplier name
and a multi-column listbox to hold part information per line. The form has
the supplier query and the listbox has the part info query with the supplier
linked to the textbox. There are no errors, it just doesn't work like I
hoped. The textbox works correctly, but the listbox only shows the first part
info record of the first supplier.
I think I'm going to try working on a subform, but I don't know exactly how
to do it.
each supplier. (I need it in a report so it can be interactive, open specific
forms for each part, etc.)
Example:
Supplier A
- Part 1
- Part 2
- Part 3
Supplier B
- Part 1
- Part 2
....etc.
My idea is to use a continuous form with a textbox to hold the supplier name
and a multi-column listbox to hold part information per line. The form has
the supplier query and the listbox has the part info query with the supplier
linked to the textbox. There are no errors, it just doesn't work like I
hoped. The textbox works correctly, but the listbox only shows the first part
info record of the first supplier.
I think I'm going to try working on a subform, but I don't know exactly how
to do it.