A
Al Camp
I have a product form w/subforms that multiple users fill in with defect data on a
production line. (Access 97)
No production users will be working on the same record at the same time.
Multiple defect entries are made in a subform of that product record.
There is code in the OnCurrent event of the form (and in the subform/s) that set
certain values on
the form, according to the data from that particular record... and data looked up from
other other tables.
(ex. has the product on this record shipped yet)
Everything is OK up to here.
However, there are times when a supervisor on the network wants to look at how
a particular inspector is getting along with the defect logging process. So, they access
that same form, and go to the record that is being edited on the floor.
After about 15 secs, this causes the floor users subform to jump up to Row1 in the
subform.
Even though the supervisor has NOT edited that record, the Current code (or some other
"automagic" code) is what is probably
triggering, what appears to be, the floor users "requery"
Any suggestions as to how to "disable" the supervisors "peek" at the active record?
Some locking scheme? (tried EditedRecord Locking... no joy)
A new copy of this form, for supervisors, with no code?
Just looking for "general" recommendations as to how to proceed with this problem.
Thanks,
Al Camp
production line. (Access 97)
No production users will be working on the same record at the same time.
Multiple defect entries are made in a subform of that product record.
There is code in the OnCurrent event of the form (and in the subform/s) that set
certain values on
the form, according to the data from that particular record... and data looked up from
other other tables.
(ex. has the product on this record shipped yet)
Everything is OK up to here.
However, there are times when a supervisor on the network wants to look at how
a particular inspector is getting along with the defect logging process. So, they access
that same form, and go to the record that is being edited on the floor.
After about 15 secs, this causes the floor users subform to jump up to Row1 in the
subform.
Even though the supervisor has NOT edited that record, the Current code (or some other
"automagic" code) is what is probably
triggering, what appears to be, the floor users "requery"
Any suggestions as to how to "disable" the supervisors "peek" at the active record?
Some locking scheme? (tried EditedRecord Locking... no joy)
A new copy of this form, for supervisors, with no code?
Just looking for "general" recommendations as to how to proceed with this problem.
Thanks,
Al Camp