Code:
SELECT tblSchools.NewSchoolsID, tblSchools.SchoolName, tblSchools.SchoolAddress, tblSchools.SchoolPostCode, tblSchools.SchoolSuburb, tblStates.SchoolState, tblSchools.SchoolPhone, tblSchools.SchoolEmail, tblSchools.[1ContactName], tblSchools.[1ContactSurname], tblSchools.StateIDFROM tblStates INNER JOIN tblSchools ON tblStates.[StateID] = tblSchools.[StateID]
WHERE (((tblSchools.SchoolName) Like "*" & [Forms]![frmSchoolSearch]![txtSchoolS] & "*") AND ((tblSchools.SchoolPostCode) Like "*" & [Forms]![frmSchoolSearch]![txtFilterSchoolPostCode] & "*") AND ((tblSchools.SchoolSuburb) Like "*" & [Forms]![frmSchoolSearch]![txtSchoolSub] & "*") AND ((tblSchools.SchoolPhone) Like "*" & [Forms]![frmSchoolSearch]![txtPhone] & "*") AND ((tblSchools.SchoolEmail) Like "*" & [Forms]![frmSchoolSearch]![txtEmail] & "*") AND ((tblSchools.[1ContactSurname]) Like "*" & [Forms]![frmSchoolSearch]![txtSurname] & "*") AND ((tblSchools.StateID)=Nz([Forms]![frmSchoolSearch]![cmbState],[tblSchools]![StateID])))
ORDER BY tblSchools.NewSchoolsID;