Search results

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...