Results 1 to 4 of 4

Thread: Combo Box Issue

  1. #1
    Join Date
    Dec 2011
    Posts
    5

    Unanswered: Combo Box Issue

    Hi there everyone,

    I just have a quick (pretty sure it is quick) how to question for Access 2007.

    So I made a mistake in designing the Access 2007 databse (still learning) anyway so I need to do a workaround that requires me to make the following situation.

    So I have a table named Courses have two feilds CrsID and CrsName. In a form there will be a combo box that EU will select CrsName. I need the CrsID to then update to a separate combo box that will be hidden to help update other combo boxes. I know I need to do a "After Update" Event Procedure on the CrsName combo box but I cannot figure out the VB code to push the CrsID to the other combo box.

    If you're wondering the mistake I made, it was a relationship mistake and I am this close to being done and just need the quick fix.

    Free Mojito to the sexy one who save my rear.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Is this what you're trying to do?

    Autofill

    Even if not, it has an example of copying a value.
    Paul

  3. #3
    Join Date
    Dec 2011
    Posts
    5

    Solved

    That worked great. Thanks a ton!

    *Hands over Virtual Mojito*

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Virtual Mojito?!?! Those aren't as refreshing as real ones!

    Happy to help.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •