I have a db that is used for creating several different labels.
I need help building a form that will allow the user to select multiple selections from a list box for the purpose of using those selections in a queries criteria. For example:
I built a query for labels but want to have multiple criteria to the "group" field. I built a list box that shows all the groups and added a button on the form that will run the labels report. The query the report is based on has the following expression in the group field Forms!Labels!group.
When i run the button on the form, the labels report gives me error in place of the address.
Also, when i try to run just the query i get no records returned. I imagine the query is not getting the values from the list box.
Is there a bettery way to do this?
thanks
I need help building a form that will allow the user to select multiple selections from a list box for the purpose of using those selections in a queries criteria. For example:
I built a query for labels but want to have multiple criteria to the "group" field. I built a list box that shows all the groups and added a button on the form that will run the labels report. The query the report is based on has the following expression in the group field Forms!Labels!group.
When i run the button on the form, the labels report gives me error in place of the address.
Also, when i try to run just the query i get no records returned. I imagine the query is not getting the values from the list box.
Is there a bettery way to do this?
thanks