Results 1 to 2 of 2
  1. #1
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67

    Opening Form in Data Entry Mode Problem

    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

  2. #2
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    alsoto,

    Have a look at the attached sample I have given you 2 forms to choose from you can complete the form by either Customer (Name) or SSN

    Have a look at the tblPayments and you will see that very little is recorded.

    You could also have a form with say a list box or combo box and when you select the SSN number it could open the form to a new record with the SSN filled in - but why have 2 form when one will do.
    Last edited by ansentry; 05-29-2009 at 07:57 AM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 10-22-2022, 08:27 AM
  2. Form Data problem
    By rjjhome in forum Forms
    Replies: 7
    Last Post: 05-29-2009, 11:51 AM
  3. Form Data Entry Problem?
    By corystemp in forum Database Design
    Replies: 1
    Last Post: 03-21-2009, 02:29 PM
  4. Replies: 1
    Last Post: 03-15-2009, 04:46 PM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums