How to requery a query in a SubForm

[Simon van Beek]

Dear reader,



After same changes it is required to requery (refresh) query in a sub form.

The code below is not working:



Me.Refresh

Forms!MasterFor m!SubForm!Form. Refresh

or

Forms!MasterFor m!SubForm!Form. Requery

or

Forms!MasterFor m!SubForm!Form. Recalc



Is it possible to do a requery for a query in a subform and what is the code
syntax?



Thanks for any help.

Kind regards,

Simon

[Salad]

Re: How to requery a query in a SubForm

Simon van Beek wrote:

Dear reader,
>
>
>
After same changes it is required to requery (refresh) query in a sub form.
>
The code below is not working:
>
>
>
Me.Refresh
>
Forms!MasterFor m!SubForm!Form. Refresh
>
or
>
Forms!MasterFor m!SubForm!Form. Requery
>
or
>
Forms!MasterFor m!SubForm!Form. Recalc
>
>
>
Is it possible to do a requery for a query in a subform and what is the code
syntax?
>
>
>
Thanks for any help.
>
Kind regards,
>
Simon
>
>

I do Me.SubformName. Form.Requery and it works.

I think you put a . instead of a ! in front of the word Form it would work.

Sleep

http://www.youtube.com/watch?v=HgQejnOWCEE