By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

How to refresh data on a MainForm

P: n/a
Dear reader,

I have a Form with a SubForm.

On the MainForm there is a field receiving his content from a group query.

If a change or append or delete a record in the SubForm the group query will
cam up with another value.

How can I refresh the value as result from the group query in the MainForm
without closing and reopen the Form.

Docomand Requiry ?

Forms!FormName.Refresh ?

These commands do not help me.

Thanks for any help.

Kind regards,

Simon van Beek
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
S. van Beek wrote:
Dear reader,

I have a Form with a SubForm.

On the MainForm there is a field receiving his content from a group query.

If a change or append or delete a record in the SubForm the group query will
cam up with another value.

How can I refresh the value as result from the group query in the MainForm
without closing and reopen the Form.

Docomand Requiry ?

Forms!FormName.Refresh ?

These commands do not help me.

Thanks for any help.

Kind regards,

Simon van Beek

YOu might want to try the format
Forms!MainForm!FieldName.Requery
if the field is a calculated field. Otherwise you can try
Forms!MainForm.Form.Requery
in the AfterUpdate event of the subform.
Nov 13 '05 #2

P: n/a
S. van Beek wrote:
Dear reader,

I have a Form with a SubForm.

On the MainForm there is a field receiving his content from a group query.

If a change or append or delete a record in the SubForm the group query will
cam up with another value.

How can I refresh the value as result from the group query in the MainForm
without closing and reopen the Form.

Docomand Requiry ?

Forms!FormName.Refresh ?

These commands do not help me.

Thanks for any help.

Kind regards,

Simon van Beek

YOu might want to try the format
Forms!MainForm!FieldName.Requery
if the field is a calculated field. Otherwise you can try
Forms!MainForm.Form.Requery
in the AfterUpdate event of the subform.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.