I have a listbox on a form that is based off a grouped query. For example:
Listbox: lstRequestedSoftwareAmalgamated
Query: qRequestedSoftwareAmalgamated, with the following fields grouped:
How can I do this? When each selected listbox items represents just one record I can do that, but how do I get it to cycle though that group of records a selected line in the listbox represents.
So 1 list item could be:
Title: Illustrator
Version: 2016
ConfigInfo: [user config text here]
Locations: 20
And that would represent 20 records grouped.
So when they select that listbox item, I want the fields on the form to add data to field(s) for each 20 records.
I need this to be a listbox, because a user will be selecting more than one (grouped) item at a time to insert field data into.
Thanks for any pointers
Listbox: lstRequestedSoftwareAmalgamated
Query: qRequestedSoftwareAmalgamated, with the following fields grouped:
- Title (group by)
- Version (group by)
- ConfigInfo (group by)
- [other grouped fields...]
- Locations (count of IDRequestDetail)
How can I do this? When each selected listbox items represents just one record I can do that, but how do I get it to cycle though that group of records a selected line in the listbox represents.
So 1 list item could be:
Title: Illustrator
Version: 2016
ConfigInfo: [user config text here]
Locations: 20
And that would represent 20 records grouped.
So when they select that listbox item, I want the fields on the form to add data to field(s) for each 20 records.
I need this to be a listbox, because a user will be selecting more than one (grouped) item at a time to insert field data into.
Thanks for any pointers