Private Sub cmdFind_Click()
DoCmd.OpenForm "frmQuickPaymentAdd", , , "[SocialSecurity] = '" & Me.SSN & "'"
End Sub
Using the above to open frmQuickPaymentAdd based upon a social security number entered in a text box - it opens the form showing the first record in the underlying table that matches that particular social security number. I want the form to open so a new record (payment) can be added for that social security number.
When I change the above to
DoCmd.OpenForm "frmQuickPaymentAdd", , , "[SocialSecurity] = '" & Me.SSN & "'", acFormAdd
The form opens in data entry mode, but the social security number isn't carrying over to the new form. All the fields on the new form are blank.
Same thing happens when I use the orig code above and make the form's data entry = yes in form property sheet.
How do I accomplish what I am trying to do?
Thanks in advance,
Al Soto