C
carriey
I have a Main Form which has tabs on it that house a number of subforms (some
with an additional subform inside them). All are working fine however, some
of the subforms contain multiple records and I want the user to be able to
select which record they want to view.
Frm_CasingFailure_MAIN is one of them and it's record source is
Qry_CasingFailure_MAIN.
I set up another subform (continuous) Frm_CF_Select which uses the same
query but the form only has a couple of fields: CF_ID, Detection_Date,
CF_Status. I would like the user to select the record here and have it show
up in Frm_CasingFailure_MAIN.
I have tried on CF_ID Got Focus and On Click the following:
Me.Frm_CasingFailure_MAIN.Form.Requery
and
Me.Frm_CasingFailure_MAIN.Form.Refresh
but both give me a Compile Error "method or data member not found" I have
checked the spelling of everything and it is correct. Can someone please
tell me what I'm doing wrong?
Thanks in advance!
with an additional subform inside them). All are working fine however, some
of the subforms contain multiple records and I want the user to be able to
select which record they want to view.
Frm_CasingFailure_MAIN is one of them and it's record source is
Qry_CasingFailure_MAIN.
I set up another subform (continuous) Frm_CF_Select which uses the same
query but the form only has a couple of fields: CF_ID, Detection_Date,
CF_Status. I would like the user to select the record here and have it show
up in Frm_CasingFailure_MAIN.
I have tried on CF_ID Got Focus and On Click the following:
Me.Frm_CasingFailure_MAIN.Form.Requery
and
Me.Frm_CasingFailure_MAIN.Form.Refresh
but both give me a Compile Error "method or data member not found" I have
checked the spelling of everything and it is correct. Can someone please
tell me what I'm doing wrong?
Thanks in advance!