Results 1 to 3 of 3
  1. #1
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95

    Automatical population of a textbox if a combobox contains specific word

    Hello there.. I will not write much as the picture below says it all



    Click image for larger version. 

Name:	Automatical filling of a textbox if a combobox contains specific word.jpg 
Views:	14 
Size:	270.8 KB 
ID:	24150

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    In the afterupdate event of the combo

    Code:
    sub cboInput_afterupdate
      select case true
            CASE instr(cboInput,"BB")>0
               txtOUTPUT = "BB" 
            CASE instr(cboInput,"CD")>0 
               txtOUTPUT = "CD" 
            CASE instr(cboInput,"FR")>0 
               txtOUTPUT = "FR" 
            CASE ELSE
               txtOUTPUT = "?" 
      end select

  3. #3
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    This works perfect.. Thank you so much...

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

Similar Threads

  1. Populate Word template with data from textbox
    By Kevo in forum Database Design
    Replies: 2
    Last Post: 10-18-2014, 07:57 AM
  2. Replies: 3
    Last Post: 08-27-2014, 07:05 AM
  3. Replies: 4
    Last Post: 06-18-2013, 01:44 PM
  4. Replies: 1
    Last Post: 06-15-2012, 05:51 PM
  5. Access - Automatical retrieve files
    By eric.kung in forum Access
    Replies: 8
    Last Post: 08-18-2011, 06:51 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