Field Up Date

[Bob Line]

Hi I need to pick up a Policy Date of a car by inserting the vehicle
Registration number.

I have a table called (tblFleetReg) which has the field (RegNumber) and the
field (PolDate) the fields store all the reg. numbers and the Policy Dates.
Note not all of the reg. no's are on our system.

When I am adding a new record to my Incident Data Form, I would like it to
update my PolicyDate field if the reg. number is on our system.

How do I go about setting this up?

Any help would be very much appreciated.

Thanks Bob

 

[Gerald Stanley]

If the form had text boxes txtRegNumber and txtPolDate, you
could set the controlSource of txtPolDate to
=DLookUp("PolDate" , "tblFleetReg" , "regNumber = '" &
txtRegNumber & "'")

Hope This Helps
Gerald Stanley MCSD