How to refresh data on a MainForm

[S. van Beek]

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

[Salad]

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.

[Salad]

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.