If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform to select record for subform
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! |
Thread Tools | |
Display Modes | |
|
|