I would not do this. IMHO you shouldn't be storing a value that can't be
calculated. If you really want this, you could add code in your data entry
form to update the ID Code based on your expression.

--
Duane Hookom
Microsoft Access MVP


"4charity" wrote:

I would like to automatically create the data for a field in my main customer
table. It is the ID code for the customer, which is the first 4 letters of
their last name, and the first letter of their first name. I am using the
expression:
=Left([LastName],4)&Left([FirstName],1).
This works fine in queries, but I really want it as the Default Value in my
table that info is entered into. Can this be done? I can't get it to work.
If not, suggestions on how to go about doing this?

Thanks.