Populate Model #

[Guest]

In the ControlSource for the text box MODEL#, try something
like

=DLookUp("Model#" , "Table2" , "[Last 3 Digits] = " &
Right([{serialnumbertextbox}] , 3))

You will have to replace {serialnumbertextbox} including {}
with your own text box name.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Hi.
I'd like to know if anybody can help me with a form and table I created.

Table1 contains Acct#, Model # and Seial #
Table2 contains Model# and Last 3 digits#
Form1 contains Date, Name, Acct#, Model # and Seial #

I have a form where I have a Text box where I have to

enter the serila number which is 15 digits long (e:
000503919206100) and another text box name MODEL# where I
would like to have the Model number populated automaticaly
everytime I enter the Serial number.

For the serial number to look for the values the table2 it's the one that should work.
Table2:
Model# Last 3 digits
a100a 150
b200b 100

Let's say I enter 000503919206100 as a Serial # then the

Model # will display b200, because it will look on table2
for the last 3 digits of the serial number entered before.