hunterfan48
Registered User.
- Local time
- Today, 11:02
- Joined
- Aug 17, 2008
- Messages
- 436
If I have a field that is just set up as a number field, is there specific code that will generate the next number in sequence?
Each of my customers in my customers have an ID. This field is a number field. On one of my forms, I have all my customers listed in a combo box for entering a sale. When I go to select the customer, I've created a Modal Dialog popup form to enter the information about a new customer that doesn't yet exist. Is there a way to automatically prefill the ID field with the next number in sequence?
Let's say I have 25 customers. I enter a customer in my combo box that hasn't been added yet, so my new form pops up. As it pops up, I want it to prefill the ID field with the number 26....the next number in sequence.
So, is there code to do this?
Thanks,
Brady
Each of my customers in my customers have an ID. This field is a number field. On one of my forms, I have all my customers listed in a combo box for entering a sale. When I go to select the customer, I've created a Modal Dialog popup form to enter the information about a new customer that doesn't yet exist. Is there a way to automatically prefill the ID field with the next number in sequence?
Let's say I have 25 customers. I enter a customer in my combo box that hasn't been added yet, so my new form pops up. As it pops up, I want it to prefill the ID field with the number 26....the next number in sequence.
So, is there code to do this?
Thanks,
Brady