Requery on a subform 1

[rjm13]

Hi All,

I have a subform, that has two list boxes on it. What I want to do is on the double click action of the first list box to cause a requery of the second list box. I am having no luck with the syntax. I have tried many combinations of the subform and object name without any luck. I keep getting error messages such as "You can't apply filter action to this window" Can anyone help? TIA

R

 

[Remou]

Have you tried (?):
[tt]Me.Combo2.Requery[/tt]

 

[rjm13]

Thanks REMOU! Thats what I was looking for. I was using the DoCmd Requery and having no luck at all! Your way is much easier..... Thanks again.

R