ChristineMD
Board Regular
- Joined
- Jul 29, 2008
- Messages
- 53
Working iwth catalog data - 24 catalogs per year, within each catalog there are up to 7 "offers" - so I have this huge long list of catalogs/offers that a user could selet any combination thereof to generate query/report
I have populated a multiselect list box on a form with all the catalog/offer info from a query - no problem. HAve the extended flag to true/yes. The form works.
Want to take selections from this multi select list box and load into a temp table that will be used to filter further queries/reports.
I've seen a lot of variations on this theme in my googling, but they seem way more involved for what I need. I think. I'm a VB noob. All the ones I've run across seem to have multiple list boxes on the form, or the results are going to a text string, etc. Can't find examples of exactly what I'm looking for.
Using access 2010
Results will be one field: "offer" but there will be multiple offers selected, want that list of offers loaded into a table.
I've seen murmurings that I need to be concerned with users unselecting items in the list? Is this true? The selections will be reset each time the form is loaded -the selections don't need to be saved from instance to instance if this makes sense. They're going to open the form, make selections, click a button which will create the temp table. Then they'll have another form to select a report/query to run which will already be joined to the temp table.
So looking for an example of loading mutli selects from a list box into a table.
I always get such great responses from this group, so I thank you in advance. Please let me know if further info is needed!
I have populated a multiselect list box on a form with all the catalog/offer info from a query - no problem. HAve the extended flag to true/yes. The form works.
Want to take selections from this multi select list box and load into a temp table that will be used to filter further queries/reports.
I've seen a lot of variations on this theme in my googling, but they seem way more involved for what I need. I think. I'm a VB noob. All the ones I've run across seem to have multiple list boxes on the form, or the results are going to a text string, etc. Can't find examples of exactly what I'm looking for.
Using access 2010
Results will be one field: "offer" but there will be multiple offers selected, want that list of offers loaded into a table.
I've seen murmurings that I need to be concerned with users unselecting items in the list? Is this true? The selections will be reset each time the form is loaded -the selections don't need to be saved from instance to instance if this makes sense. They're going to open the form, make selections, click a button which will create the temp table. Then they'll have another form to select a report/query to run which will already be joined to the temp table.
So looking for an example of loading mutli selects from a list box into a table.
I always get such great responses from this group, so I thank you in advance. Please let me know if further info is needed!