Results 1 to 2 of 2
  1. #1
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58

    Use double click on Form to copy field value to another table

    I have a form which I would like the user to double click on the field SOLSONO and the value of that field to be copied to another table



    Form Name frmUnprintedWorkSheets
    Field Name SOLSONO

    Table Name tblWorkOrderReport
    Field Name fldPartNum

    I have tried several ways but cannot get the syntax of the sql insert correct.

    TYIA
    Bill

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    something like

    currentdb.execute "INSERT INTO tblWorkOrderReport (fldPartNum) VALUES (" & SOLSONO & ")"

    this assumes SOLSONO is numeric. If it is text

    currentdb.execute "INSERT INTO tblWorkOrderReport (fldPartNum) VALUES ('" & SOLSONO & "')"

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

Similar Threads

  1. Replies: 4
    Last Post: 06-17-2019, 05:17 PM
  2. Replies: 2
    Last Post: 08-07-2017, 02:58 PM
  3. Replies: 3
    Last Post: 07-22-2015, 03:45 AM
  4. Replies: 10
    Last Post: 09-17-2013, 05:22 PM
  5. Replies: 8
    Last Post: 05-26-2011, 09:23 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