Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    86

    Unanswered: submit data to a new table

    I have a table called id cards. I also have a form called id card form. Now i use the form to submit data into the table. i want to add a button to submitt only a few records that i want into a different table. the new table is Order id cards. So when the user presses this button it will submit the current record to this new table not all 3000 records? Any tips please email me

    Pete

  2. #2
    Join Date
    Jun 2004
    Posts
    55
    use the .AddNew function, there's a file in help for it.

    Dim rst As RecordSet

    Set rst = currentdb.OpenRecordSet ("NameofTable")
    rst.AddNew
    rst![ColumnName1] = [CorrespondingControlName]
    .
    .
    .
    .
    rst.Update

  3. #3
    Join Date
    May 2004
    Posts
    86
    what does this mean [CorrespondingControlName]

  4. #4
    Join Date
    Jun 2004
    Posts
    55
    Basically I mean the name of the textbox, dropbox, or listbox on the form that holds the data that you want to go into that specified column.

Posting Permissions

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