Parameterized query as row source
Posted on 2006-10-19
Hello and thank you for reading my question.
I would like to use a parameterized query as my rowsource for a combo box. The query requires two parameters, both text.
I have tried using the following, but it does not work: that is to say no errors occur, but no results are returned when I know that there should be 4 (that is what I get when I double click on the query and enter the two parameters.
Here is the relevant code:
strParameter1 = "Florida"
strParameter2 = "Miami"
Me.cboLocations.RowSource = "EXEC qryLocationsByStateAndCity '" & strParameter1 & "','" & strParameter2 & "'"
Would someone tell me what I am doing wrong please?