Results 1 to 5 of 5

Thread: Access Annoyance: ComboBox Ordeal

  1. #1
    Board Regular
    Join Date
    May 2007
    Posts
    588
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Access Annoyance: ComboBox Ordeal

    Okay, I create a combo box in my form, to work with a query below. It is supposed to search for two columns in the query. It works at first. Then, I change the combo box to sort ascending and then it goes bonkers.. When I click on a name/area (my two fields) it will find the name but a difference area not associated with the selection?? What the heck? Access you are so random and annoying.

    I recreate the combo box, use it for awhile, It works, I change nothing.. and then all of a sudden, it doesn't as well? Help please. I have refreshed all and I have compact and repaired the database.. so far.. its an ongoing issue. It hates me.

  2. #2
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,491
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Access Annoyance: ComboBox Ordeal

    Best in this case would be to find a nearby Access expert to help you. The problem itself can't be resolved without more information - what is the combobox source? How is it linked? What happens on when you click the combobox.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  3. #3
    Board Regular
    Join Date
    May 2007
    Posts
    588
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Annoyance: ComboBox Ordeal

    Unfortunately, there are no Access DB sources in my area, otherwise, I would definitely reach out. This is the only source besides Google that I have. The combo box is linked to a table I loaded, in the table, I even CTRL and marked any keys that can link. Should I only make 1 item a primary key? If I click in the combo box, my name and my area show, but when selected the query below either goes to some other person or area, or same person different area than selected. Unfortunately the data is secure so I cannot share it on here. I have played around with this thing so much, I setup the combo box by using the tool and it appears to work at first but then it doesn't. It makes no sense to me?

  4. #4
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,491
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Access Annoyance: ComboBox Ordeal

    All tables should have primary keys. So if you are using data without a primary key ... well, basically there is no guarantee of correct queries anymore.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  5. #5
    Board Regular
    Join Date
    Jul 2010
    Posts
    459
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Annoyance: ComboBox Ordeal

    Can you share a copy with no data or mock/test data?

    Your description of what you are trying to achieve is unclear.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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