andrewf10
Registered User.
- Local time
- Today, 14:55
- Joined
- Mar 2, 2003
- Messages
- 114
Hi folks,
I have 2 forms on a table. Record locking is set to 'edited record'.
User 2 goes onto Form 2 and edits record. User 1 goes onto Form 1 and presses 'save' for whatever reason.
The save button attempts to set a field (say field1) to some value but gives a run time error 13 'type mismatch'.
If the opposite is done in that form 1 is being edited and form 2 is saved (same field1 is changed), a different run time error occurs (2448) which is the one I'd expect in a user locking situation.
The only difference between the forms is that Form1 allows records to be created and Form2 only allows them to be edited.
Is this normal? Is there a way around it?
Any help to solving this annoying problem would be greatly appreciated
I have 2 forms on a table. Record locking is set to 'edited record'.
User 2 goes onto Form 2 and edits record. User 1 goes onto Form 1 and presses 'save' for whatever reason.
The save button attempts to set a field (say field1) to some value but gives a run time error 13 'type mismatch'.
If the opposite is done in that form 1 is being edited and form 2 is saved (same field1 is changed), a different run time error occurs (2448) which is the one I'd expect in a user locking situation.
The only difference between the forms is that Form1 allows records to be created and Form2 only allows them to be edited.
Is this normal? Is there a way around it?
Any help to solving this annoying problem would be greatly appreciated