Form input into table = Serial# and Product

[ChadMan]

I have a serial number system for 40+ products
Examples:
ESS3XXXX
USXXXXX
ULPXXXX

The prefix = the product type.

I have a table "ProductList" with 2 columns

Prefix Product
-------------------
ESS3 Extender Set
US Universal Set

etc...

I would like to input a serial number, have it tell me what product it is in
another text box. Can I write a script with rules based on the prefix to do
this and have it update the form and another table as well?

 

[Guest]

I see what might be a problem. Your product IDs are different lenghts. It
looks like the digits are all 4 characters. If the is true then use this as
criteria in a query --

Left([SerialNumberField], Len([SerialNumberField] - 4)

You will get the ProductID.