help in autonumber

[Amy]

Hi,

I have linked an oracle database in access and created a
form to update/add data to the database. However,
the 'ID' column in the database is in 'number' format.

1: How can I change this 'number' format to 'autonumber'?
I tried to do this in access, but i can't make any changes
to the table design because it is a linked table.

2: is there a way that i can use a code to populate
that 'ID' column automatically?

any ideas? TIA...

 

[Steve Schapel]

Amy,

I know nothing about Oracle, but I suspect it does not have anything
corresponding with Access's autonumber data type.

One simple approach would be to put the equivalent of this in the
Default Value property of the ID control on your form...
DMax("[ID]","NameOfYourTable")+1

- Steve Schapel, Microsoft Access MVP