467,104 Members | 1,027 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

How to requery a query in a SubForm

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!MasterForm!SubForm!Form.Refresh

or

Forms!MasterForm!SubForm!Form.Requery

or

Forms!MasterForm!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
Aug 15 '08 #1
  • viewed: 17037
Share:
1 Reply
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!MasterForm!SubForm!Form.Refresh

or

Forms!MasterForm!SubForm!Form.Requery

or

Forms!MasterForm!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

Aug 15 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Kurt | last post: by
4 posts views Thread by midlothian@gmail.com | last post: by
7 posts views Thread by SBC News Groups | last post: by
1 post views Thread by Stinky Pete | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.