Continuous form bound to a Sharepoint List (1 Viewer)

BiigJiim

Registered User.
Local time
Today, 08:21
Joined
Jun 7, 2012
Messages
97
Hi all,

We have an Access FE which links to a Sharepoint List containing about 70 fields. Each record in the list is completed in a 2 stage process, by different users. Stage 2 cannot be worked until Stage 1 is completed. A continuous form "frmAllocate" is bound to this list and can update two fields, to allocate the Stage 1 and Stage 2 user. The allocation form is only available to a couple of Admin users. Every other user can then see the records allocated to them and can edit each record individually.

The problem we are experiencing is that Admin users tend to keep the Allocation screen open for long periods, but it does not seem to refresh automatically when another user makes changes in a record. So for example:
1) the admin user opens the Allocation form at 9am,
2) a Stage 1 user completes their section of a record at 9.20am
3) at 9.30am the admin user navigates to that record and updates the field which allocates it to a Stage 2 user

In this scenario the changes made by the Stage 1 user are lost, as the continuous form saves the record based on the state of the record at 9am when the allocation form was first opened.

Is there any way of automatically making the continuous form auto-refresh periodically, as it would if it was linked to an Access BE? I know I can use a timer event or something to force a refresh of the continuous form at regular intervals, but is there any better way of doing it? Seems very clunky.

Thanks for any help!
Jim
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 08:21
Joined
Jul 9, 2003
Messages
12,117
It appears that, (probably due to the the political upheaval) your question has been missed. I'm bumping it up the list for another vote!
 

BiigJiim

Registered User.
Local time
Today, 08:21
Joined
Jun 7, 2012
Messages
97
It appears that, (probably due to the the political upheaval) your question has been missed. I'm bumping it up the list for another vote!
Thanks Uncle Gizmo
 

Users who are viewing this thread

Top Bottom