Suborm Recordset Clone

[fabby1]

Hi People

I have a form and a subform.

The main form displays the details about the employee e.g. Name address etc.

The subform contains any sickness the employee has.

They are based on two seperate querys

And they are linked by the STAFFNo

1. Is this the best method

I have input boxes on the main form so the user can enter sickness details.

How can I write into the subform the newly entered sickness record and how can I reference the subforms recordset to enter new data.

Thanks

Phil