I have a MS Access 2000 Database. I have an autonumber field called Record ID (Primary Key). I have a form built from a querey in the database called Records. Can a form be created that does not immediately access the table from which the form was created and assign a new autonumber. I have thought of possibly splitting the database, but do not have much experience with this aspect. I am not sure if this would suffice. I am trying to keep a multi user environment from accessing the form, starting to fill it out, and changing their mind and closing the record. At this point, the autonumber is already assigned and I need to keep the records in true sequential order.
Points for this problem will increase if the solution is clear and works.