Dear All,
I have a form with 3 unbound controls, a subform and a command button.
When the button is pressed, a query is fired. The problem is this: when I
dont put anything on the 3 unbound controls and press the command button,
nothing is displayed on the subform. If I fill one or two of the unbound
controls nothing is also displayed, however, when I fill all of the unbound
controls, that's the only time the query works. The 3 unbound controls should
all be filled up before it will display anything.
The query for the command button is this:
Form_frmApplicantssubform.RecordSource = "Applicant List Query Filter
VCG2d"
and the contents of the Applicant List Query Filter VCG2d is this:
SELECT * FROM tblApplicants
WHERE (COURSE Like "*" & forms!frmFS!txtCourse & "*" OR
COURSE Like "*" & forms!frmFS!txtCourse2 & "*" OR
COURSE like "*" & forms!frmFS!txtCourse3 & "*")
ORDER BY names;
Any ideas where I went wrong? Thanks in advance for the help.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1