DLookup

  • Thread starter Thread starter Chuck305
  • Start date Start date
C

Chuck305

Hi

I have the following fields in a table “TrainNumberâ€, “InspDateâ€,
“CurrentInspHours†, “LastInspDate†and “LastInspHoursâ€

I would like to populate LastInspDate & LastInspHours on the data entry form
automatically I believe DLookup is what I need to use but I don’t have a clue
of how to code it.

Any help with this would greatly appreciated.
 
Hi Chuck,

All of the domain aggregrate functions (DLookup, DMin, DMax, etc.) are used
to retrieve data from tables, not to write data. You can use the
Form_BeforeUpdate procedure in VBA code to update the LastInspDate field.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Back
Top