Sending control value to subform

[bfamo]

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.

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?

 

[PWise]

The Fourth prameather in open form is the where condishion

the syntex is
fieldname=value

not controlname=xxx

 

[MajP]

Like Pwise said you need a Sql Where clause without the word "where".

"CaseID = " & Forms![FrmSearch]![CaseID]

Unless caseID is text then

"CaseID = '" & Forms![FrmSearch]![CaseID] & "'

 

[bfamo]

Thanks for quick response

When refering to the CaseID-field in frmCustomerSub, I have to include [Red]"Me!frmCustomerSub!CaseID"[/Red], right?
If I dont do, I would basically say that the CaseID-field is located on frmCustomer and not on its subform.

 

[MajP]

I might be confused, but when you open frmCustomer don't you want to go to a specific record on the main form and show all related records in the sub? Or is the main form unbounded and the subform shows your records?

if it is the latter then in the search form

DoCmd.OpenForm "FrmCustomer", acNormal
forms("frmCustomer").frmCustomerSub.form.recordset.findfirst "[CaseID]= " & me![CaseID]