Run query based on value in combobox

[tobinjames]

I have a form with a combobox containing a list of elements. The row source type for the combobox is a query (SELECT Elements.Element FROM Elements ORDER BY Elements.Element). I would like to run a different query depending on the element selected in the combobox.



Each query will be a parameter query, the parameter values being provided by text boxes on the form.

I was thinking that I could add a column to the Elements table to hold the name of the query associated with each element.

I am not sure how to retrieve both columns from the Elements table into the combobox so that the query could be executed by clicking on a button on the form.

Any advice would be much appreciated.

[alansidman]

This video should get you started.

http://www.datapigtechnologies.com/f...earchform.html

Alan

[orange]

What exactly do you want to see?
What is the purpose of the combobox?

Please help us help you.