Results 1 to 2 of 2

Thread: Append Query

  1. #1
    Join Date
    Jan 2002
    Location
    Attleboro, MA
    Posts
    5

    Unanswered: Append Query

    What is the syntax for tell a quey to append only the record choosen, ie. wher the curser is???
    Any help is greatly appreciated.

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    Suppose you have a form with textbox named txtUserID, then an append query may look like this:


    dim strSQL as String

    ' design your query
    strSQL= "INSERT INTO tblMain (Field1, Field2) SELECT Field1, Field2 FROM tblAnotherTable WHERE UserID=" & me.txtUserID & ";"

    ' execute your query
    CurrentDB.Execute strSQL

    HTH,

Posting Permissions

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