I wish to generate a unique CustomerID for a customer table in Access.

[Park Inn]

The customerID must be unique. It must have three letters followed by 4 numbers [EBC1234]. How can I get MS Access to generate a new customerID using a query and then run a macro/command button to add the new customerID to a new record. VBA code is not necessary. Any help would be gratefully appreciated.

[ADezii]

You can create a Function, that will generate this Unique Customer ID as you describe, and write it to a Table. I see no other Method to accomplish this, other than VBA Code.

[dsatino]

I would have to agree with ADezii, you're going to need some code.