Results 1 to 3 of 3
  1. #1
    t_dot is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2010
    Posts
    17

    Post Combobox and table interference


    Hi, I have a form that has different textFields and comboBoxes that a user fills out, presses a "submit" button and that data is added on as a new entry to an existing table. All of these things appear in the table afterward, and the text shows up as is it supposed to but the values from the comboBox show up as digits instead of the values (Line, Transformer, Breaker, Capacitor, etc) that are in the comboBox itself.

    I realize that these must be connected, but how do I go about putting the actual value into the table from the form instead of the referenced number?

    Any help is greatly appreciated.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    it sounds like you have a multiple column combo. do you? If so, and if you're using code to insert the record, make sure you reference the right column of the box. if the box is simply bound to the table field, then make sure the source of the box lists the column values that you want in the actual field FIRST in the list of the sql statement you see in the props

  3. #3
    t_dot is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2010
    Posts
    17
    You are right, I did have two columns but had set only one to show up in the table. I had an ID number column -- stupid mistake! haha

    Thanks!

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

Similar Threads

  1. Please I need help with combobox
    By em12 in forum Access
    Replies: 1
    Last Post: 07-16-2010, 08:04 AM
  2. Combobox help
    By rnjalston in forum Forms
    Replies: 1
    Last Post: 04-02-2010, 06:37 PM
  3. help with combobox
    By ManC in forum Forms
    Replies: 0
    Last Post: 03-15-2010, 08:27 PM
  4. Replies: 0
    Last Post: 12-16-2009, 01:14 PM
  5. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 08:03 AM

Tags for this Thread

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