I can get the form to open. I get an error message and the
Forms!frm_combined_CNVs.frm_sample_cnv1.Form.Filter = Criteria1
I also tried this method without success: DoCmd.OpenForm
"frm_combined_CNVs", , , "Forms!frm_combined_CNVs.frm_sample_cnv1.Form.[sample_id] = '" & sample_id & "'
I'm attaching a sample database. All patient related information has been removed. "Form1" button contains the code that opens "frm_combined_CNVs" form.
Any advice/suggestions will be greatly appreciated.
Thanks for your help, Mila