S
sebastian stephenson
I would like to open a Report using a filter condition. The current filter:
tbl_phpc_dataStore1.case_ref_id=Forms![frm_case_details]!case_ref_id.Value
works fine, but I want to use the same Report to look at a same field when
loaded from a different Form.
The reference to the new filed/form is:
Forms![frm_case_details_data_input]!case_ref_id.Value
I want to create a test condition in the filter statement so that, if the
first form is open, use the case_ref_id. If the first form is closed use the
case_ref_id on the 2nd form. - "frm_case_details_data_input"
Can I create a condition in the filter statement????
This would be the efficient method to creating the same report twice
referring to another form.
Please hlep.
tbl_phpc_dataStore1.case_ref_id=Forms![frm_case_details]!case_ref_id.Value
works fine, but I want to use the same Report to look at a same field when
loaded from a different Form.
The reference to the new filed/form is:
Forms![frm_case_details_data_input]!case_ref_id.Value
I want to create a test condition in the filter statement so that, if the
first form is open, use the case_ref_id. If the first form is closed use the
case_ref_id on the 2nd form. - "frm_case_details_data_input"
Can I create a condition in the filter statement????
This would be the efficient method to creating the same report twice
referring to another form.
Please hlep.