DLookup

[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.

 

[Tom Wickerath]

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/
__________________________________________