Help with populating Form Detail section with query results

[Darkmatter5]

I have a query:

SELECT dbo_jobs.JobID, dbo_jobs.JobNumber, dbo_jobs.JobDescription, dbo_jobs.JobLocation, dbo_subdivisions.SubdivisionName, dbo_jobs2surveys.SurveyID
FROM dbo_subdivisions INNER JOIN (dbo_jobs INNER JOIN dbo_jobs2surveys ON dbo_jobs.JobID = dbo_jobs2surveys.JobID) ON dbo_subdivisions.SubdivisionID = dbo_jobs.SubdivisionID
WHERE (((dbo_jobs2surveys.SurveyID)=[Forms]![Search Form]![cb_Survey]));

I have a form that consists of a combobox "cb_Survey", a button that applies the forms filter and a detail section that I need to populate with the results from the query. Here is the code run by the button.

Private Sub btn_RunQuery_Click()
    lb_SearchStatus.Caption = "Search results for the survey of " & Me.cb_Survey
    Me.Filter = "([SurveyID]='" & Me.cb_Survey & "')"
    Me.FilterOn = True
End Sub

When the button is clicked the label is updated, but nothing happens to the detail area.

The form's "Record Source" is set to the query and the "Control Source" of the items in the detail section are set to the appropriate fields from the query set in the form's "Record Source".

I'm lost, please help!

[jzwp11]

Welcome to the forum!

I would remove the WHERE clause from the query since you are filtering the results using the code.
Is the surveyID field a numeric datatype or a text datatype?

[Darkmatter5]

Welcome to the forum!

I would remove the WHERE clause from the query since you are filtering the results using the code.
Is the surveyID field a numeric datatype or a text datatype?

SurveyID is numeric, int.
I also removed the WHERE clause. the query is now.

SELECT dbo_jobs.JobID, dbo_jobs.JobNumber, dbo_jobs.JobDescription, dbo_jobs.JobLocation, dbo_subdivisions.SubdivisionName, dbo_jobs2surveys.SurveyID
FROM dbo_subdivisions INNER JOIN (dbo_jobs INNER JOIN dbo_jobs2surveys ON dbo_jobs.JobID = dbo_jobs2surveys.JobID) ON dbo_subdivisions.SubdivisionID = dbo_jobs.SubdivisionID;

I'm now getting the following error.
"Run-time error '3464': Data type mismatch in criteria expression."

What exactly does "Me.cb_Survey" return? Is it the value column of the combobox? When I created the combobox, I opted to hide the ID field.

Thanks for the warm welcome!

[Darkmatter5]

Figured it out, SurveyID is an int, so I don't need the single quotes denoting that it's a string. Thanks for getting my brain synapses firing!

[jzwp11]

Glad you got it worked out!