I have come across numerous postings about setting the record source of a subform but I am still not able to find a solutio
to my problem.
I am using Access 2007 and based on a query constructed in a search form I am setting the record source of a subform on a new
form I am opening to display the search results.
I am using the following code:
[Form_New Course Booking]!SfStudentSearchResults.Form.RecordSource = studentSearchQuery + whereClause + ";"
MsgBox ([Form_New Course Booking]!SfStudentSearchResults.Form.RecordSource)
DoCmd.OpenForm "New Course Booking"
After I set the record source the message box displays the correct query as the record source but when the new form is
opened it still displays the old/default record source.
I would really appreciate it if somebody could guide me in the right direction here.