Change data in table using VBA

[spudracer]

I've got two separate tables, "tblPersonnel" and "tblReports."

What I want to be able to do is update a report date in the personnel table once a report on that person is completed in the reports table.

They are both linked by MemberID and ReportID fields, but what is the code I would need to make this happen?

 

[jdraw]

It sounds that you may have a many to many relationship between these tables.
Is it possible you need a junction table, such as tblPersonnelReport, that permits multiple Reports per person?

 

[spudracer]

Possibly. This date will change on an annual basis. Possibly earlier, but there will only ever be one actual date in the field in the personnel table, which would be the most recent report's completion date.