I have a main form frm_Main and on the main form i have a subform sub_Main.
On the sub_main i have set the onload to execute the following -
DoCmd.OpenForm "sub_LeaveApproval", , , "[startdate] = #18/11/2003#"
When i execute the sub_main form as a standalone form the filter works fine but when the sub_main is within the frm_main the filter does not work.
Any Ideas
carlp69
On the sub_main i have set the onload to execute the following -
DoCmd.OpenForm "sub_LeaveApproval", , , "[startdate] = #18/11/2003#"
When i execute the sub_main form as a standalone form the filter works fine but when the sub_main is within the frm_main the filter does not work.
Any Ideas
carlp69