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_frmApplica ntssubform.Reco rdSource = "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!txt Course & "*" OR
COURSE Like "*" & forms!frmFS!txt Course2 & "*" OR
COURSE like "*" & forms!frmFS!txt Course3 & "*")
ORDER BY names;
Any ideas where I went wrong? Thanks in advance for the help.
--
Message posted via AccessMonster.c om
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_frmApplica ntssubform.Reco rdSource = "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!txt Course & "*" OR
COURSE Like "*" & forms!frmFS!txt Course2 & "*" OR
COURSE like "*" & forms!frmFS!txt Course3 & "*")
ORDER BY names;
Any ideas where I went wrong? Thanks in advance for the help.
--
Message posted via AccessMonster.c om
