I designed a form using visual basic as the interface and access as the database for customer entry of data. I did use the record count method to ensure that the customer ID is autonumber. However, when deleting a customer record and upon adding new records the same number is used, and the previous records customer IDs are changed. How can I solve the problem programmatically? Please help.

Vincent

[Edited by Kiptalam on 12-07-2000 at 01:00 AM]