Is it Possible to Reference a SubForm in DoCmd.SearchForRecord?

[NeoPa]

From Referring to Items on a Sub-Form, you could also shorten it a little further with :

Forms!frmLoans.sfrmAppraisals!Recordset.FindFirst "AppraisalID = " & Me.txtAppraisalID

This is example of appreciating where dot and bang make most sense.

I would also suggest that if you are going to use this new procedure for the subform (and there's really no reason why you wouldn't), then it would makes sense to use that same procedure for the other form too - to provide consistentcy.

Private Sub Command4_Click()
    DoCmd.OpenForm "frmLoans"
    With Forms!frmLoans
        .Recordset.FindFirst "LoanID = " & Me.txtLoanID
        .sfrmAppraisals!Recordset.FindFirst "AppraisalID = " & Me.txtAppraisalID
    End With
End Sub

[Seth Schrock]

So the procedure for the other form would be

Forms!frmLoans.Recordset.FindFirst "LoanID =" & Me.txtLoanID

I get an error saying "can't find the field 'Recordset'" when I take the .Form out from before it. I tried . instead of !, but that broke it as well (as you probably already knew).

[NeoPa]

I think I was editing and improving my post as you were testing that Seth. Can you try the code as it is now (in post #16) and tell me what errors you get, if any. You need to be clear which lines you're talking about when reporting that, of course.

[Seth Schrock]

I get the same error message(Microso ft Access can't fin the field 'Recordset' referred to in your expression) on your line 5.

[NeoPa]

Very strange. What do you get if you try :

.sfrmAppraisals.Form.Recordset.FindFirst "AppraisalID = " & Me.txtAppraisalID

Maybe the ! shortcut only works for controls on the form. I've never had to use the .Form. syntax before.

[Seth Schrock]

That works great. That is also the same as what I had before only in With/End With form (which I like as it is neater).

[NeoPa]

A new thread - Discussion: Dot Versus Bang (Again) - has been created to handle the discussion that developed from looking for the best answers for this question.