Wet_Blanket
Registered User.
- Local time
- Today, 15:34
- Joined
- Dec 3, 2008
- Messages
- 113
Greetings - I am running on Access 2003.
I have a table that has a field which is an autonumber. The problem is that I have an Auditrail Mod (from Irish) on a form that requires a Record ID (autonumber) to run. However, Access doesn't let me have two autonumbers in the same field. So when I update a record through the form, I get an error and the audit trail doesn't get populated with my updates.
Is there a way to get around this issue using code?
I have a table that has a field which is an autonumber. The problem is that I have an Auditrail Mod (from Irish) on a form that requires a Record ID (autonumber) to run. However, Access doesn't let me have two autonumbers in the same field. So when I update a record through the form, I get an error and the audit trail doesn't get populated with my updates.
Is there a way to get around this issue using code?