Prefix Autonumber with characters from another field

[Fireman1143]

I need to refix the autonumber feild with the first three characters from the Last Name field in the same table. Obviously it needs to change the autonumber AFTER the Last Name is entered into the record, not when the record opens.

Any ideas would be appreciated.

 

[MoLaker]

You won't be able to do this to the autonumber directly as the data type is long integer. But, there is more than one way to skin a cat and we need to fully understand your goal before making recommendations. Exactly how is this new number to be used? Are we talking about an existing DB with several records or are you starting from scratch?

"Retired Programmer", that is. So, please be patient.

 

[MakeItSo]

Add another column to your table, e.g. "GUID".
Do you use a form to enter data?
If so, you could bind a text field to this column, add a "Save" button, and in its click event:

Sub Savebtn_Click()
Me!Guid=Left(Me!LastName,3) & Me!ID

Or the like...

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell

 

[Fireman1143]

Thanks to both of you. Your input made it easier to figure how I wanted to format and get this.