Private Sub cmdFind_Click()
DoCmd.OpenForm "frmFindStudents", , , "[LastName] = '" & Me.LastName & "'"
End Sub
How do I add [FirstName] to the code above so that form opens with matching [FirstName] AND [LastName]?
Thanks,
Al
Private Sub cmdFind_Click()
DoCmd.OpenForm "frmFindStudents", , , "[LastName] = '" & Me.LastName & "'"
End Sub
How do I add [FirstName] to the code above so that form opens with matching [FirstName] AND [LastName]?
Thanks,
Al
Try:
Code:Private Sub cmdFind_Click() DoCmd.OpenForm "frmFindStudents", , , _ "[LastName] = '" & Me.LastName & "' AND [FirstName] = '" & Me.FirstName & "'" End Sub
Thanks RG!
You're welcome. If this problem is solved then try the link in my sig.
Better yet, I'll fix the link in the sig to point here.
Done. Thanks Again!
Excellent! Thank you.