thao-nhi
asked on
How to build a query that takes label caption as a criterion
I have a form with a panel of about 20 labels. Each one will have a SKU as a caption. I want to build a flexible query that grabs the label caption as a criterion when the label is clicked. I am using access 2010. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have good VBA knowledge then you should try Event Sinking and avoid the tedious task of clicking 20 labels to add code on Click event.
ASKER
Where would I read up more about Event Sinking? thanks
Note: The form needs to be open when the query runs.