amend records in subform with control on main form

[emcf]

Hi Folks

it has been a while since I've been on this site and I have a daft question for you access pros out there!

I have a DB (purpose is to record projects and those working on the projects). I have a main form which shows the projects and details and the subform shows the staff members working on the projects.

I have a button on the main form that closes the project and removes it from the open list of projects - when i click this button I want the some fields in the subform records to be updated/filled in - how would i go about this?

 

[emcf]

thanks uncle gizmo - you are correct in both your assumptions.

I'll have a dig about on those topics and will repost if (when!) i have any more questions.

 

[emcf]

Thanks Again Uncle Gizmo, job now done!