Search problem with form

[JackT]

I have the following form that has a field that searches for a reference number. When I enter the numbe and hit search I get a pop up wanting me to enter the Enter the parameter value for Me.cmbRef

here is the code
'This is the select criteria for reference number
Me.RecordSource = "SELECT * FROM qryCheckFiles WHERE Me.cmbRef = [APU REFERENCE NUMBER]"
' These are the two boxes populated with data
Text6 = [APU Reference Number]


Text9 = [PayeeName]

If i remove the where part of the query Text6 and Text9 do not get updated. I need to know how to search on the ref number with out the popup box.
Thanks
Jack

[pbaldy]

You'd have to concatenate the form reference:

Me.RecordSource = "SELECT * FROM qryCheckFiles WHERE " & Me.cmbRef & " = [APU REFERENCE NUMBER]"

Which presumes it's a numeric field.

[JackT]

thanks

Jack