I have a Customer Database, with Customer ID's that start from 1, and so on. Now I have a UserForm that Add a Customer to a Database. but I need to manually enter the new User ID. Is it possible to write a code to automatically put the next available number in TextBox1 ?
Thanking you in advance,
Jakes
Bookmarks