Can't seem to find the right syntax for the parent form to change the filter for a child and requery the RecordSource of the child. The child is "frmRoomAssignments".
This is wrong:
Me!Form("frmRoomAssignments").Filter = "RetYear = " & """" & gblRetreatYear & """"
Me!Form("frmRoomAssignments").FilterOn = True
Me!Form("frmRoomAssignments").Requery
Thanks for any help,
Bill