Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Evansville, Indiana, USA
    Posts
    111
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Write Records ON_CLICK event (2000)

    Here is what the requester wants:
    When a new user is added to the program, once the OK button is selected, 7 records need to be written to a table. Here is what I have:

    Private Sub btnAddRecord_Click()
    On Error GoTo Err_btnAddRecord_Click

    DoCmd.GoToRecord , , acNewRec
    Me.JanW1D1 = 12345

    Exit_btnAddRecord_Click:
    Exit Sub

    Err_btnAddRecord_Click:
    MsgBox Err.Description
    Resume Exit_btnAddRecord_Click

    End Sub

    When I click the button, it adds a record to the table with the JanW1D1 field set to 12345. However, instead of adding 1 record, I want to add 7 records. How do I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Write Records ON_CLICK event (2000)

    It appears that this is a continuation of the thread begun in <post#=425618>post 425618</post#>, so I'm locking this thread and requesting that the topic be continued in the existing thread.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •