Field Up Date

  • Thread starter Thread starter Bob Line
  • Start date Start date
B

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
 
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
 
Back
Top