I have a form (form A) with information about vehicles. These vehicles have to periodically inspected.The date when the vehicle is inspected is filled in.

In an other form (form B) I can plan this periodically inspection wich will be shown in a calender. In this form B I would like to add an input field where the new inspection date can be filled in.

So when a new inspection date is filled in form B it has to update the inspection date in the record generated by form A.

There is a report based on form A which shows the oldest inspection date, so we always know which inspection has to be planned in as first.

How do I do update the record in form A bases on a field in form B?

I'm really stuck.

Hope to hear from someone soon, the application has to be ready next week.

Greats,

Erwin Fennema