Results 1 to 2 of 2
  1. #1
    NickWren is offline Advanced Beginner
    Windows XP Access 2013
    Join Date
    Dec 2015
    Location
    Connecticut
    Posts
    70

    List from a Textbox

    I have two textboxes on a form one called ScannedText and the other one called SamplesScanned



    We have a barcode scanner that scans in samples into ScannedText and this needs to transfer the scanned in name to SamplesScanned creating an array of the samples.

    Example:

    *Scan First Sample*
    [ScannedText:] PL-0001-NT

    [SamplesScanned:] PL-0001-NT


    *Scan Second Sample*
    [ScannedText:] PL-0002-NT

    [SamplesScanned:] PL-0001-NT, PL-0002-NT

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    In the after update event of the first, this type of thing:

    Me.SamplesScanned = Me.SamplesScanned & "," & Me.ScannedText

    You can add code to get rid of the leading comma.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 12-22-2015, 09:09 PM
  2. Replies: 5
    Last Post: 04-30-2015, 01:50 AM
  3. Replies: 1
    Last Post: 04-16-2014, 07:28 PM
  4. Replies: 2
    Last Post: 04-20-2013, 03:37 AM
  5. New to VBA - Textbox/ List question
    By dreamnauta in forum Programming
    Replies: 6
    Last Post: 12-21-2011, 01:41 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