Winterwolf73
New member
- Local time
- Today, 15:55
- Joined
- Jul 3, 2020
- Messages
- 26
I am creating a form where the user can add new customers to the table. As I was creating the form, I realized there is no was to know what the next available account number will be. I initially tried the "go to last record" macro. Well I quickly learned that is not going to work without the table being open (not what I want to do.) So I started the research to find a better method. I found everything from DLookUp to DMax to DMin. From what I have read these really don't fit the job.
What I would like to do is when the "Find Account" button is clicked a mgsbox appears with the last used account number. Unless there is a way to automatically create the next available account number when the "add new customer" button in clicked.
Any help would be GREATLY appreciated.
What I would like to do is when the "Find Account" button is clicked a mgsbox appears with the last used account number. Unless there is a way to automatically create the next available account number when the "add new customer" button in clicked.
Any help would be GREATLY appreciated.