Cascading Combobox Weirdness

[Archie999]

This is really driving me nuts!

I have a cascading combobox (2 combos). The first one works fine... let's me choose values from a table in my DB.

The second combobox values will depend on what is entered in the first one. I have a query with 3 fields:

MyCategoryID - Bound Column
CategoryName - To display in the combobox
ProductID - The first combobox value

I want to display the Category Name only in the combobox (Yes, I know it seems weird that I have different Categories of a Product instead of vice-versa but trust me... It's correct)

Here is the weirdness. If I choose to hide the 1st and 3rd columns so that I should only see the Category Name, I see nothing. There are no values when I drop down the combobox.

But... if I choose to display the CategoryID, it works. I see the numbers in the drop down list (useless!). It also works if I choose to display both the CategoryID and the CategoryName. But this too is undesirable.

Can anyone think of something I could be doing wrong? It's got me stumped. BTW - I've read just about every single thread on cascading comboboxes.

Thanks as always!

Arch

 

[Pat Hartman]

Make sure the column count and the bound column properties are set correctly.

 

[Archie999]

Reset object properties fixed this

Thanks Pat... they were both fine and I guess I'm chalking this up to Access weirdness.

In case anyone comes across a similar issue and hence this thread this is what I did to resolve the issue.

- I imported the applicable objects into a brand new test database and it worked fine.

- I went back to the real DB and I changed my form properties back to default values. I had wanted to have this form as popup and modal for data entry only and so, I had quite a few restrictions on it. I turned them all off and my combobox worked.

- I turned all of my restrictions back on, one by one to see if I could find the offending one but it worked after each one.

- My form is now set exactly as it was before but the combo boxes work.

Just FYI