I have a form / subform where users enter details on subform. They then select which records they wish to view on the subform, and view a report from the main form which is filtered by this indicator field. At the moment I use a temporary indicator field on the subform recordsource to do this.
This all works fine until I have concurrent users, then one user's selections impact on another.
I need to somehow set the subform so that users can enter and record data directly to table, but keep the indicator field changes held locally so that changes are not seen by other concurrent users.
Am I making sense?
Can anyone help?
This all works fine until I have concurrent users, then one user's selections impact on another.
I need to somehow set the subform so that users can enter and record data directly to table, but keep the indicator field changes held locally so that changes are not seen by other concurrent users.
Am I making sense?
Can anyone help?
