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
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