Results 1 to 3 of 3
  1. #1
    Hale is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    2

    Combo Box Coding


    Okay here's the question, it's probably a simple one for everyone here, but I've been trying for over a month now and can't get this right. I have a form, and on this form there is a combo box at the top with the names of certain people, and below that are text boxes which should have something other than #NAME in them. These names were taken from a table from the same databse (obviously). Also on the table are other pieces of information about them (coulmns) that have their first name, last name, city, state, zip, etc. In case anybody doesn't yet get where I'm going with this, the form is (supposed to be) a mirror of the table, but I want to have it so that when you click someone's name on the combo box in the form, all the other info magically appears in the text boxes below the combo box. I have been working with this: http://www.access.qbuilt.com/html/find_a_record.html , and it is exactly what I want to do, but it's not working for me. Can anyone help me, please? Thanks.

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Your combo box Row Source is set to a table that does not exist in your database, and your form does not have a Record Source.

    Cheers,

  3. #3
    Hale is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    2
    Thank you for your response. How do I establish a record source to my form? I have the form set to the right table this time, but I know my code is still wrong and I still can't the names listed in my combo box. Thank you.

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

Similar Threads

  1. Coding for Empty Combo Box
    By gazzieh in forum Programming
    Replies: 1
    Last Post: 03-26-2010, 05:22 PM
  2. Button Coding
    By yamie in forum Programming
    Replies: 3
    Last Post: 02-22-2010, 10:45 AM
  3. Adding VB code on a embedded coding for a button
    By cwwaicw311 in forum Programming
    Replies: 1
    Last Post: 02-20-2010, 12:25 PM
  4. Bar-Coding
    By texasprincess7 in forum Access
    Replies: 1
    Last Post: 02-12-2009, 10:29 AM
  5. parsing data in access (coding?)
    By banker247 in forum Programming
    Replies: 0
    Last Post: 01-13-2009, 12:05 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