I'm doing something along these lines:
recmdb.AddNew
recmdb.Fields("ObjectType" = ObjectTypeCombo.Text
recmdb.Update
However the Access database that I'm adding the record to has an ID field which is autonumbered.
At any point after the AddNew method I need to know what the autonumber given was.
If its not given a number until the .Update method has completed I'm happy to wait until then.
Any ideas?
elziko
recmdb.AddNew
recmdb.Fields("ObjectType" = ObjectTypeCombo.Text
recmdb.Update
However the Access database that I'm adding the record to has an ID field which is autonumbered.
At any point after the AddNew method I need to know what the autonumber given was.
If its not given a number until the .Update method has completed I'm happy to wait until then.
Any ideas?
elziko