Autonumber through a form, not a table

[Kat-ness]

In short, we're using Oracle to back up the records on an Access database. The tables are all in Oracle and I don't have the ability to manipulate them like I could in Access. Apparently, autonumber is not done with Oracle tables so I need to find another way to set up an autonumber.



Does anyone know how to do this in Access without using tables? Can I create an autonumber on a form?

Thanks,
Kat-ness

[June7]

If you can't set up field in Oracle to automatically increment, then need code in VBA to generate a custom unique ID. The trick is figuring what event to put code in.

Custom unique ID is common topic in forum. Search forum or Google.

For a start review:
https://www.accessforums.net/access/...ers-21361.html

http://forums.aspfree.com/microsoft-...ta-403208.html

[Kat-ness]

Thanks June,
I saw something else on how to do a code to create an autonumber so your comments definitely support that. I appreciate your help.