Subform requery fails

[Rats]

I have used the following command on a command button to requery my subform and it works as I planned. However, if I copy it to say,the OpenEvent for the same form, nothing happens. I'm obviously missing something here.

[Forms]![Customers]![mysubform].Form.Requery

All help appreciated thanks

 

[wazz]

i don't think you need a requery on an open event as it requeries automatically when opened (which is why you are using it to begin with, because you haven't closed and reopened the form - you're "requerying" instead of closing and reopening). yes, there's something missing here, either in your description or in what you want to do.

 

[neileg]

Syntax should be:

[Forms]![Customers]![mysubform].Requery

 

[Rats]

Thank you both for your replies.
The problem actually lay with where I was trying to run the command from.
The subform was on a tabbed control which I neglected to mention. I was trying to run the requery on the subforms Events and tried every possiblity without any luck. In the process of experimentation I clicked on the border of the form and actually selected the Subform/Subreport window which only had two event choices-"On Enter and On Exit". I added my requery to the ON Enter and voila she works beautifully.

Thanks again