A selective Combo Box

I want to use a Combo box on a sub-sub-form that only shows a selection from a table depending upon a value on the Master Form. ( in Access97)

I have setup the Combo box to obtain its values from a query. That query refers to the control on the Master Form ([Forms]![MaterForm]![control]) and when run manually does what I want.
However, it refuses to be selective when the Combo Box is clicked, it returns all records not the selection!

I happen to also have the control value on the sub-sub-form, it is stored with that forms data. I have tried refering to it with the query and still no joy!

I don't know if it is relevant but the Master to sub-form is not a master/child relationship, whereas the sub/sub-sub forms are.

Try the following code in the after_update event of the combobox

[forms].[formName].[objectname].requery

S-

S.
Thanks but that does not work, it would be after the list is displayed! Putting it on a Got Focus or Click does not either! I have even tried on an After Update on the control on the Main Form. Still no luck :-(
Peter

Could you post a sample of your DB, I would need to see it to fine tune the troubleshooting.

S-