Requery in a subform

[dduffy]

I have a requery function on a listbox. This runs fine when the listbox and the action (to tell when to requery) are in the main form. However if I base the action in the subform I get the error 'You can't use the ApplyFilter on this window'

I have checked the properties on the main and sub-form and they both are set to allow filters.

I am using list22.requery for the actual requery function, but as I say it works fine if I have the listbox and the button in the main form.

Is there some other property I am missing?

 

[cuok]

hi friend,

are u correctly refering to the listbox?

here exp. to refer to control in sub form and requery it:
[Forms]![frmMain]![FormSub].[Form]![control].requery

i hope its good 4 u.