Refresh Parent from a Subform without Requery Subforms

[Guest]

Hello,

is it possible to refresh data in the actual record of a parent form (when
the focus is in a subform) without requerying the subform(s)? So that that i
can go on editing e. g. the next/prev. record of the subform without falling
back to the first record.

Thanks for a answer.

Tobias

 

[Guest]

I'm not sure it will work, but try using refresh instead of requery, if it
doesn't help, you can run a requery on the main form, and using a bookmark
returning back to the reocrd.

 

[Guest]

Hello,

thanks for the answer. But it doesn't helps. The parent as well the child
form are requeried after Refresh. Both positions in the Recordsets are going
back to the first row. When entering data into the child form this is not
practical.

Tobias

 

[Michael Cheng [MSFT]]

Hi Tobias,

We are not able to refresh the data in parent form while keep the subform
still. Access is designed to refresh the subform query whenever any column
in parent form are updated.

However, let's look into the design of your forms. Is it possible for you
to consider changing the form design or subform query filed definition?


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.