combobox limiting combobox, requery not working

[DahMurf]

I have a Main Form which has a subform within it. They both open visible. I have a combobox named type on the main form. I have a combobox named class on the subform that through a query uses the type combobox selection to limit what is displayed in the class combobox.

When the type value is first selected the class list is correct.

My problem is if the user made a mistake and has to change the value in the type combobox. If they do that the class combobox is not changing to the new limited list.

I coded both of the following on the after update of the type combobox (both to cover all basis):

Forms!MainForm![SubForm].Requery
me!refresh

I can't code a requery on the mainform because it will cause all of the users data to be lost.

Does anyone have any idea why this won't work or how I can get the refreshed list I need when the first combobox is changed?

Thanks in advance.

 

[PHV]

Have you tried this ?
Forms!MainForm![SubForm].Form![class].Requery


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DahMurf]

Nope! Big DUH on me! hehehe

That worked great! Thanks so much!
I was looking too hard!