var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can I set a Condition in a Query from a list box
I have a form which has one combo and lists text. The user can pick any one from this list. I have a button to open the query dependant on the their choice.
I also have a query but would like the query to return the results where the condition is the same as the text picked from the combo box.
It seems that I cannot use docmd.openquery as it does not give me the option for a condition.
in the criteria for your query you could add in
but, while editing the query, you may have to go to Query -> Parameters to add in this with the correct data type.