Add a sequential alphanumeric record to a table

[joemennell]

I have an Access table with records that have a two letter, two number alphanumeric identifier (AA01, AA02 etc)
I am trying to create a form whereby, when the user types in the first two letters, the next sequential number from the table is generated.
The letters can be totally random and selected by the user, but the numbers do need to be sequential.
Can anyone help??:banghead:

 

[burrina]

You can create a mask for your criteria.
Example:

[InvNo] & "-" & [PrimaryKey] & "000"

HTH