Hi!
I have three forms:
frmSearch (Based on a query, contains a control [CaseID])
frmCustomer (With control [CustomerID])
frmCustomerSub (With control [CaseID])
Here is what is supposed to happen:
When I press button btnNext in frmSearch, the value in frmSearch!CaseID is passed to frmCustomer!frmCustomerSub.Form!CaseID.
I have tried this code, but it looks as if the code can't find the control I'm refering to. I get prompted to insert a value for Me![FrmCustomerSub].form![CaseID].
Can someone please help me with this?
I have three forms:
frmSearch (Based on a query, contains a control [CaseID])
frmCustomer (With control [CustomerID])
frmCustomerSub (With control [CaseID])
Here is what is supposed to happen:
When I press button btnNext in frmSearch, the value in frmSearch!CaseID is passed to frmCustomer!frmCustomerSub.Form!CaseID.
Code:
DoCmd.OpenForm "FrmCustomer", acNormal, , "Me![FrmCustomerSub].Form![CaseID]=Forms![FrmSearch]![CaseID]"
I have tried this code, but it looks as if the code can't find the control I'm refering to. I get prompted to insert a value for Me![FrmCustomerSub].form![CaseID].
Can someone please help me with this?