Update two tables from one field on form

[ptrifile]

I have 2 tables, one that holds current mileage of a vehicle (this is updated on a weekly basis for all vehicles) then i have another table that holds maintenance for vehicles and what the mileage is when the maintenance is done.

Maintenance is not done weekly on a vehicle so when maintenance is done i would like the mileage to not only update the "mileage" field in the tblmaintenance but also in the tblcurrentmileage table. Updating the weekly mileage and maintenance info is done via different forms.

When the maintenance form is updated how would i get both tables "Mileage" to be updated?

I have tried playing around with update queries but just cant seem to get it to do what i need. can anyone help here?

Thanks in advance!

Paul

 

[dhookom]

Could you share your table structures and form record source(s)?

Duane
Hook'D on Access
MS Access MVP