Results 1 to 4 of 4
  1. #1
    mattn is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2019
    Posts
    2

    Question Compile two fields into one, without overwriting using a command button

    I have a table, with fields REMARKS, STATUS DT and STATUS. I am attempting to combine the two STATUS fields into REMARKS using a command button. I am currently using [REMARKS] = [STATUS DT] & " " & [STATUS] on click, however all it does is grab the two fields and overwrite the REMARKS field. I need that data once entered to compile and not overwrite. By the way, I am a total noob to VBA. Thanks everyone.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Maybe?
    Code:
    [REMARKS] = [REMARKS] & " " & [STATUS DT] & " " & [STATUS]

  3. #3
    mattn is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2019
    Posts
    2
    JoeM, thank you worked like a charm... you are awesome.

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome.
    Glad I was able to help!

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

Similar Threads

  1. Replies: 7
    Last Post: 01-28-2019, 04:33 AM
  2. Replies: 5
    Last Post: 05-10-2014, 12:25 PM
  3. Replies: 3
    Last Post: 05-16-2012, 10:20 AM
  4. Command Button Wizard and Matching Fields
    By tylerg11 in forum Forms
    Replies: 5
    Last Post: 10-07-2011, 01:07 PM
  5. Replies: 1
    Last Post: 07-27-2010, 02:27 PM

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