Autogenerate Number on a form.

[hursan1710]

Hi,

I have a new customer account form, see bellow, all files will be manually enter and a new entry will be generated on the customer contact table once "Save record" is click, but i want to automatically generate a number by clicking "Generate MailStop" and that number be enter on the MailStop box. this number should start with 7894561 and go from there.
can anyone help me?

[pbaldy]

Most common is using DMax() and adding 1. Dangerous to put it behind a button if you have multiple users that could be adding customers.

[Micron]

You might be OK if you enforce the record to be saved first, then write the generated number to the table whereupon it will display in the control. I agree with pbaldy that to create the number first and put it into the table some time after is not advisable. You would open the form and ensure the generate button is disabled, then enable it after the record saving has taken place.
Edit:
as an afterthought, you might want to review information regarding form design with effective placement of controls in mind. Having an action button that comes after a close or cancel button in the visual path is not an example of good design. This page might be of some help http://uxmovement.com/buttons/why-ok...-on-the-right/

[hursan1710]

Thank you....