Is there any way to change the recordsource of a subform from the mainform?
I have a subform that I would like to have return data from a table based on selections from multiple checkboxes on the main form. When these selections are made I want the recordsource of the subform to update according to this criteria
My main form is called EDIT_PARAMETERS and the subform is called SF_EDIT_PARAMETERS. I have tried a few different code snippets and have had zero luck.
This is an example of the type of recordsource that I would like to assign to the subform - RecordSource = "SELECT [ITEMNMBR], [LOCNCODE], [VALIDATE], [ORDERING_ALLOWED], [INV_REQUIRED], [MAX_QTY], [TIMEFRAME] FROM [BRANCH_ORDER_VALIDATION_PARAMETERS] ORDER BY [LOCNCODE], [ITEMNMBR]"
I don't want to use the filter because I am going to have multiple criteria and am not sure if I would be able to anyway.
Any help would be greatly appreciated.
Thanks,
Chuck