Program equivelent of "Records refresh"

[John Baker]

Hi:

I have a Pop Up form that involves a main form and sub form. The sub form has the results
of a query on the main form.

I need to automatically perform exactly he same action that takes place when I manually
click "Records/refresh" when I update a field on the main form, but am having trouble
making that happen. Me.Refresh does not do it, and neither do any of the other things that
I have tried. "Records refresh" has the effect of updating the query in the sub form,
based on changes to the main form. This is what I need to have happen programmatically.

Help..Please

John Baker

[Wayne Morgan]

If Me.Refresh was being run from the main form, it would refresh the main
form. The Me keyword refers to the form or report that the code is running
on. To refer to the subform, you first need to refer to the subform control
on the main form, then to the subform.

Example:
Me.ctlNameOfSubformControl.Form.Refresh

If refresh doesn't work, try requery or recalc.

--
Wayne Morgan
Microsoft Access MVP
"John Baker" <Ba******@Verizon.net> wrote in message
news:23********************************@4ax.com...

Hi:

I have a Pop Up form that involves a main form and sub form. The sub form
has the results
of a query on the main form.

I need to automatically perform exactly he same action that takes place
when I manually
click "Records/refresh" when I update a field on the main form, but am
having trouble
making that happen. Me.Refresh does not do it, and neither do any of the
other things that
I have tried. "Records refresh" has the effect of updating the query in
the sub form,
based on changes to the main form. This is what I need to have happen
programmatically.

Help..Please

John Baker

[John Baker]

Thanks..that works
"Wayne Morgan" <co***************************@hotmail.com> wrote:

If Me.Refresh was being run from the main form, it would refresh the main
form. The Me keyword refers to the form or report that the code is running
on. To refer to the subform, you first need to refer to the subform control
on the main form, then to the subform.

Example:
Me.ctlNameOfSubformControl.Form.Refresh

If refresh doesn't work, try requery or recalc.