Double Filtering from a Subform 2

[dedren]

I have a subform that I use to list some items. On that subform I made the OnClick property below:

DoCmd.OpenForm "frmSAR", , , "CaseNum= '" & CaseNum & "'" & " AND " & "ctlSARID = '" & txtSARID & "'"

It doesn't work though, and instead gives me a dialog box asking for txtSARID.

txtSARID is the name of the control on frmSAR.
ctlSARID is the name of the control on the subform.

I am trying to open frmSAR and have it open to the correct record.

The command filters fine if I only have:

DoCmd.OpenForm "frmSAR", , , "CaseNum= '" & CaseNum & "'"

 

[PHV]

What is supposed to be the value of txtSARID on the calling subform

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya dedren . . .

Try this:

[blue]   Dim Cri As String
   
   Cri = "[CaseNum]= '" & Me.CaseNum & "' AND [SARID] = '" & Me!ctlSARID & "'"
   DoCmd.OPenForm "frmSAR", , , Cri[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[dedren]

PHV: txtSARID is a text field on the form that I am trying to open. It should be 'filtering' based on the value of a text field on the subform called ctlSARID.

Both of these fields refer to an autonumber field (SARID) in a table (tblSARlst).

TheAceMan1: I tried this code but I got the error message,

"Run-time error '3464':
Data type mismatch in criteria expression.

 

[PHV]

I'd try this:

DoCmd.OpenForm "frmSAR", , , "CaseNum='" & Me!CaseNum & "' AND SARID=" & Me!ctlSARID

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dedren]

GLaDOS approves! That works perfectly!! Thank you both for your help with this.

PHV: Might I ask why yours worked?

 

[dedren]

I should tell you that there are 12 people in this office that want to kiss your face for fixing this.