Access Query from Combobox to fill Form Data Not Working
Posted on 2013-12-03
I have a form with two combo boxes, the second combo box being filtered by the first. When I make my selection in the second combo box (the Program field), I can not get the query to work to select the record of data to display in the form.
I make my selection, then I get an "Enter Parameter Value" message box that shows my Program selection as the parameter to enter. If I type the Program again in the box, my data then displays. Can anyone help me figure out what I have wrong in my query, as follows?...
Private Sub Combo340_Change()
Me.RecordSource = "Select tblContract.* From tblContract Where [tblContract].[Program] = " & Me.Combo340.Column(0)