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.