Update other table field after clicking Save button in form

[MaSaav]

I´m working on a small database for a nonprofit to keep track of children who visit our community center, but I´m not an expert at all.



After clicking Save button in frmDailyVisitsm, a new record is inserted into tblDailyVisits. After that I need it to do the following, but I have no idea on how to achieve it:

1. To update the LastVisit field in tblChildren with VisitDate value from tblDailyVisits/frmDailyVisits.
2. Calculate the difference between two dates and display a message if it´s greater than one year. These dates are stored one on each of the two tables (tblDailyVisits.Visitdate and tblChildren.LastVisit). Maybe using this expression: Int(DateDiff("d",tblChildren[LastVisit]), tblDailyVisits[Visitdate]/365.25)

I really appreciate your help.

[pbaldy]

I probably wouldn't try to store last visit, but you can use a recordset to get the current value from the children table. Compare it to the value on the form, put up your message box if appropriate, and use the Edit method of the recordset to put the new value there.

[MaSaav]

Paul, thank you for your response. I´m learning about recordsets to work on it and will let you know.

[pbaldy]

No problem, post back if you get stuck. Welcome to the site by the way!