2 Autonumbers?

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?
 
why do yuo need another number for the irish reference - why not just the one number?

=========
ie although you cant have 2 autonumbers, I cant see why you would need 2
 
Hmmm....can I change the RecordID number to the autogenerated number?
 

Users who are viewing this thread

Back
Top Bottom