Calculated field to another field

[NickWren]

Is there a way to write a vba script that will take a calculated field and write it as a string in a short text field.

Calculated field (WrenID):
[FacilityAbbr] & "-" & [ID]

[FacilityAbbr] = "PL"
[ID] = autonumber "000#"

Short Text(WrenIDString):
"PL-0001"

VBA SCRIPT? clearly I would need more for this to happen, and can I do this in a table or will it have to be in a form?



WrenIDValue = Me!WrenID.Value
WrenIDStringValue = Me.WrenIDValue




I need this for bringing over excel tables into access:

my access table creates a unique ID that we use to call all our samples, the excel spreadsheets have the unique ID as the sample name; however now there is no way to say the name on the excel spreadsheet = the unique ID that Access creates due to it being a calculated field.

[NickWren]

Here is an example of my problem: AccessForum.zip

[RuralGuy]

The simple answer is almost certainly. I successfully imported the xlsx file with no errors by lettingn Access create the Primary Key field. What you want done can be accomplished in a stand alone module.