I use the below code to filter records of the courses sub form
Expand|Select|Wrap|Line Numbers
- [Forms]![courses].Filter = "Courses.[Course Type] like '" & TypeofCourses & "'" & " and courses.[Course Title] like '" & CourseTitle & "'"
- [Forms]![courses].FilterOn = True
i got stumped by the error 2450- MS Access cant find the form frm referred to in a macro expression or visual basic code
Expand|Select|Wrap|Line Numbers
- Dim frm as string
- frm="courses"
- [Forms]![courses].Filter = "Courses.[Course Type] like '" & TypeofCourses & "'" & " and courses.[Course Title] like '" & CourseTitle & "'"
- [Forms]![courses].FilterOn = True
thx in advance