Access 2007 to Sharepoint Requery

[wineguy via AccessMonster.com]

Through a form with a sharepoint linked table as its data source, I can
successfully display modifications from form or sharepoint list modifications
ONLY when the form is closed and then re-opened.

How can form data be requeryed or refreshed without closing and re-opening
the form?

Thanks in advance,

Glynn

 

[Albert D. Kallal]

Through a form with a sharepoint linked table as its data source, I can
successfully display modifications from form or sharepoint list
modifications
ONLY when the form is closed and then re-opened.

How can form data be requeryed or refreshed without closing and re-opening
the form?

Keep in mind, this problem is not related to using SharePoint.


To force a form to "reload" records that may have been entered by others (or
by your code), you can execute a me.Requery

 

[wineguy via AccessMonster.com]

Hi Albert,

Appreciate your time and feedback.

I tried variations of the requery but none seemed to work.

I was successful by following an older post that suggested creating a dummy
form with the same data source, and on a manual or timer event, opening and
closing the dummy form in background forced the sharepoint list changes, but
that approach isn't optimal by any means.

Which form event would you recommend putting the me.requery?

Thanks again in advance,

Glynn

Through a form with a sharepoint linked table as its data source, I can
successfully display modifications from form or sharepoint list

[quoted text clipped - 3 lines]

How can form data be requeryed or refreshed without closing and re-opening
the form?

Keep in mind, this problem is not related to using SharePoint.

To force a form to "reload" records that may have been entered by others (or
by your code), you can execute a me.Requery