Stop new record

[Carl Johnman]

I have a form and unless data is entered into 4 fields on
the form I want to prevent a new record from occuring in
my table. It is creating useless order numbers and id's.
My problem is if they enter information into 1 field and
even go back and delete it I am left with a useless record
being created in the table.

Thanks for any help,
Carl Johnman

 

[Andrew Smith]

If you are using an AutoNumber field for anything that the user needs to
see, or for anything where you need a continuous unbroken sequence of
numbers, then you need to change the design. AutoNumbers will always get
gaps in them whatever you do. If this is your problem then you'll need to
find a way of generating your own order number or id.

If you want to guarantee that all 4 fields are completed, then why not make
them required fields in the table design? This will make sure that a record
cannot be saved with any of the fields blank. It will not solve the
autonumber problem (if that's what it is) as you will still get users
cancelling entry of records, and that will "use up" a number, and it will
never be seen again.