Hi all,
i wish i knew what is wrong with the query supposed i need returning records
Main form called Fr_ScheduleEditor, subform Frmsub_CourseLastRecords.
Subform has a single table as rowsourse, managed by
Subform needs to load with all records and then by two criteria from combos from main form, needs to be requeried.
For first criteria for courseID, alone
works fine
then after if plus previous requeried by
( expect to select date ) no records are shown sinse 2cond criteria is put in query..
i wish i knew what is wrong with the query supposed i need returning records
Main form called Fr_ScheduleEditor, subform Frmsub_CourseLastRecords.
Subform has a single table as rowsourse, managed by
Code:
SELECT Tbl_CourseSessions.courseID, Tbl_CourseSessions.instructorID, Tbl_CourseSessions.CourseDate, Tbl_CourseSessions.CourseTime, Tbl_CourseSessions.courtID
FROM Tbl_CourseSessions
WHERE (((Tbl_CourseSessions.courseID) Like "*" & [Forms]![Fr_ScheduleEditor]![cboCource] & "*") AND ((Tbl_CourseSessions.CourseDate) Like IIf(IsNull([Forms]![Fr_ScheduleEditor]![cboCourseDate]),"_ ;[Forms]![Fr_ScheduleEditor]![cboCourseDate]")))
ORDER BY Tbl_CourseSessions.courseID, Tbl_CourseSessions.CourseDate;
For first criteria for courseID, alone
Code:
Like "*" & [Forms]![Fr_ScheduleEditor]![cboCource] & "*"
then after if plus previous requeried by
Code:
Like IIf(IsNull([Forms]![Fr_ScheduleEditor]![cboCourseDate]);"_ ;[Forms]![Fr_ScheduleEditor]![cboCourseDate]")
Last edited: