Form Data Retrieval

[gjflash]

Help!

This is the example for my needs.

Product (Database

Product data (Table)
Serial Number (Field)
Model Number (Field)
Manufactured Date (Field)
Claim Data (Table0
Serial Number (Field)
Claim Number (Field)

Product Entry ( Form)
Serial Number (Text Box)
Model Number (Text Box)
Manufactured Date (Text Box)

Claim Entry (Form)
Serial Number (Text Box)
Model Number (Text Box)
Manufactured date (Text Box)
Claim Number Box (Text Box)

What I need is when entering data into the Claim Entry Form and the first item I type in the Serial Number.

What I want to have happen as soon as I leave the Serial Number text Box I want the Model number and Manufactured date to automatically show up in the appropriate boxes.

I the can go down and fill in the claim Number.

I only want to see this data for information and not store it any where.

Oh yes The Serial number,Model Number, Mafg date, has already been entered in the Product Data Table.

Can some one help me write the Expression to use in the control source for the appropriate text boxes.

Or am I all wet. ( I’ve been there before) I’ve tried DLOOKUP but maybe I’m not doing it right.

 

[Dustman]

Try this..

In the lostfocus even of the serial number field:

[Model Number] = DLookup("Model Number","Product Data","[Serial Number] = " & [Serial Number])

[Manufactured Date] = DLookup("Manufactured Date","Product Data","[Serial Number] = " & [Serial Number])

I think that should work.. -Dustin
Rom 8:28