Button to insert an Autonumber into an existing text field

[MyComputerGuy]

We have an Access database for quoting jobs. Currently, we enter a Quote# manually into a text field (generally a number but frequently followed by a letter). I would like to create a button that could be used to insert the current AutoNumber field data into the Quote# field. The AutoNumber would not be used for every quote.

 

[Remou]

If this is use on a form with a recordsource that includes the autonumber, you could try:

Me.txtQuoteControlName=Me!AutoNumberFieldName

 

[danvlas]

I would strongly suggest not to use AutoNumber for anything that has any meaning to the user whatsoever.
Remember: it's not guaranteed to be in sequence and it's not possible to change it.
It's only supposed to be unique.


Someday someone will ask you about the missing number. That will be an accountant, not a DBA

HTH





Daniel Vlas
Systems Consultant