Results 1 to 2 of 2
  1. #1
    btappan is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Posts
    42

    Any way to have a text box store 3 unique values based off of a single input?

    I need to be able to enter a single string of text on a form and have some predefined suffixes appended to them in a table.



    Inputting: VB500

    Would populate a table like this with these 3 suffixes

    COL1 COL2
    VB500 VB500-NEW
    VB500 VB500-USED
    VB500 VB500-REFURBISHED

    Please be specific if possible, i'm sort of a beginner to this stuff. Thanks!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,863
    You could use an option group. On your form you can create an option group using the wizard. Inside the option group you can place check boxes or radio buttons that will represent the three conditions.

    When a user ticks one of the options, the option group returns a value, an integer. You can place the integer value into column 2 of your table or you can place the literal text value. If you choose the text value, you just need to write out some VBA. perhaps a case select statement.

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

Similar Threads

  1. Replies: 5
    Last Post: 02-29-2012, 11:56 AM
  2. display a list of values based on user input
    By karl1971 in forum Access
    Replies: 3
    Last Post: 12-06-2011, 09:19 AM
  3. Hve text combo box values but store integers in field
    By accesshelpasker in forum Access
    Replies: 9
    Last Post: 10-28-2011, 10:49 AM
  4. Replies: 15
    Last Post: 04-01-2011, 11:41 AM
  5. Replies: 2
    Last Post: 08-09-2010, 06:34 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 - Senior Forums