Ray Stantz
Registered User.
- Local time
- Today, 12:14
- Joined
- Nov 16, 2006
- Messages
- 63
Hello all, i have a strange issue i hope someone has seen before.
I have a main form with about 20+ controls on it, one of which is an Audit Trail filed using a combo box and a Module setup on the BeforeUpdate Event to check and list any modifications to the saved record. The audit trail gives me the user's name, The Date the Change was Made, and The Specific field that was changed and what changed about it.
It works well with the exception that if a user simply loads a record and then moves to another record and/or form, the Audit Trail is telling me i've updated 8 specific fields every time even if nothing on the record has been manually changed.
None of the fields have a set default, the 8 fields in question are comprised of the following datatypes: text, memo and number and there are also combo boxes and two unbound controls that also show up as modified. The audit trail states that Fields 1-8 "previous value was blank" and again, nothing has been entered into these fields so they are still blank afterwards but they are still updating for some reason. This is also affecting users who do not have Update permissions for the main form, they get Error 3108 "Record cannot be edited, no update permission on Form" when they try moving from the main form to another.
Might this be the AllowZeroLength setting needs to be changed from the default (Yes) to No? Any help is greatly appreciated!
Ray
I have a main form with about 20+ controls on it, one of which is an Audit Trail filed using a combo box and a Module setup on the BeforeUpdate Event to check and list any modifications to the saved record. The audit trail gives me the user's name, The Date the Change was Made, and The Specific field that was changed and what changed about it.
It works well with the exception that if a user simply loads a record and then moves to another record and/or form, the Audit Trail is telling me i've updated 8 specific fields every time even if nothing on the record has been manually changed.
None of the fields have a set default, the 8 fields in question are comprised of the following datatypes: text, memo and number and there are also combo boxes and two unbound controls that also show up as modified. The audit trail states that Fields 1-8 "previous value was blank" and again, nothing has been entered into these fields so they are still blank afterwards but they are still updating for some reason. This is also affecting users who do not have Update permissions for the main form, they get Error 3108 "Record cannot be edited, no update permission on Form" when they try moving from the main form to another.
Might this be the AllowZeroLength setting needs to be changed from the default (Yes) to No? Any help is greatly appreciated!
Ray
