Requery with cascading combo boxes

[TanyaH]

Database1.zip

Hello everyone,

I have been struggling to make a cascading combo box that will successfully requery. When I select a value in the first combo box, my cascaded combo box shows the appropriate values. However, if I change the value in the first combo box, the second, cascaded combo box does not update its values. I have attached a very basic database in case you would like to take a look. I hope it is something simple that I am overlooking.



Thank you in advance for any help you can offer!

[Missinglinq]

...if I change the value in the first combo box, the second, cascaded combo box does not update its values...

It updates for me, which is to say the selections in the dropdown for the second Combobox are appropriate for the selection that was last made in the first Combobox.

Now the selection made from the second Combobox is still showing in that Control, after a new selection is made in the first Combobox; is that what you mean by 'does not update?' If this is what you mean, change

Private Sub ProjectCombo_AfterUpdate()
 SubCombo.Requery
End Sub

to

Private Sub ProjectCombo_AfterUpdate()
 SubCombo.Requery
 Me.SubCombo = Null
End Sub

Linq ;0)>

[TanyaH]

Hi Ling,

I really appreciate your quick reply and your clear explanation of how to update the code. Unfortunately, when I made that change, the values in the second combo box still do not update when the first combo box is changed. When I pick "Kisumu" in the first (project) combobox, the subprojects for Kisumu show appropriately in the second (subproject) combo box. However, when I change the first (project) combo box to "Meru," I would expect to see only one value available in the second (subproject) combo box, CHI, but the subprojects belonging to Kisumu still display. Can you think of anything else I might be missing?

Again, I am very grateful for your help!

Tanya

[qa12dx]

what u have seems to work fine.

some of these quirky things are because of software problem. i can't remember what problem i was having, i think it was either requery or filter, i searched on the net and found i needed to get service pack 2 for my version of access.

make sure u have all the updates installed.

[Missinglinq]

The Comboboxes work exactly as they should, for both qa12dx and myself, in the file you attached. In re-reading your original post, though, I see that you said

I have attached a very basic database

Does this means that it is not the actual file that you're having trouble with? If so, what happens when you use the Comboboxes on this file? Does it cascade properly or does it exhibit the same behavior as your original file?

Both qa12dx and myself are running Access 2007, so I suppose this could be a 2010-specific problem, but it's not one that I've seen reported on the half a dozen Access forums that I monitor daily.

Both of the Comboboxes are Unbound on the file you attached; is that the situation on the actual file you're having trouble with?

Although we usually think of Forms or entire Databases when we speak of corruption, individual Controls, such as Comboboxes, can and do become corrupted. The test and the fix are one and the same; deleting the Control then re-creating it! If it was corrupt, you've verified the fact and solved the problem! If the Comboboxes on the 'basic file' you attached work for you, need to delete and re-create the second Combobox on your original file.

The advice qa12dx gave, vis-à-vis having all updates in place, is something to consider, if all else fails. Personally, I've always been leery of applying new service packs

• Until they've been available for a while or
• I'm having problems that are documented to be resolved by a service pack

Note that I said 'personally.' Some people update every time a new SP or hotfix comes out, but all too often the fixes for one problem end up introducing other problems, so I usually give them a while to prove themselves.

Linq ;0)>

[TanyaH]

Hello,

Thank you both for your suggestions and taking the time to test the database. The database attached is not the same one I orginally had the problem with, but I am having the same issue with the attached one, and I wanted to isolate the problem as much as possible and didn't want to put too much information from my organization on the internet.

After learning that this was working for both of you, I continued to scour the internet for solutions. This is really embarrasing to admit, but hopefully will help someone in the future if they ever have the same problem...I had not enabled all content in the database and am enough of a VBA novice not to know that this would prevent the code from working. Like I said, it's embarassing.

Again, thank you so much for your replies and time. What a great resource full of kind people!

[Missinglinq]

Glad you figured it out!

Linq ;0)>

[moona]

Hi Tanya,

What did you enable to get this working?
I am having the same issue and using Access 2007.

What is enabled "all content in the database"?

Thanks

[Missinglinq]

Answered here

https://www.accessforums.net/forms/c...ing-34276.html