Use List box values as query criteria
Hi,
Please have a look at the attached test2.mdb first. There I am populating two listbox based on a dropdown selection. Now I want to run a query where I can use the selected list box values as criteria. Say I want to populate a query which retrives the result set as,
Select * from MailingList where Listbox1.value = "Pen" and ListBox2.Value = "10"
Please help.
test2.mdb
Please have a look at the attached test2.mdb first. There I am populating two listbox based on a dropdown selection. Now I want to run a query where I can use the selected list box values as criteria. Say I want to populate a query which retrives the result set as,
Select * from MailingList where Listbox1.value = "Pen" and ListBox2.Value = "10"
Please help.
test2.mdb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.