I have a form called frmAddEditFuelData which updates tblFuelLog. tblFuelLog has the following fields FuelId, VehicleID, OdoAtFillup. I need on the form Afterupdate (OdoAtFillup) to do the following, look up another table called tblVehicles if tblVehicles."StartOdo" =<0 then tblVehicles.StartOdo = tblFuelLog."OdoAtFillup" where tblFuelLog."VehicleId" = tblVehicles."VehicleID"
then it need have a msgbox (No Start miles has been set for this Vehicle, this will be StartOdo) vbok. after ok has been clicked I need it to Delete current record with no msg telling them it is deleting the record and then close the form