Add A New Record to a Tabbed Form?

[cscott007]

hi I am not the best at Databases so please be kind...

I have been tasked with building a database to be used by nurses collecting certain information.

I have a form with 4 Tabs
Main Details, Employment Details, Episodes and Events.

In short One Employee can have many Episodes and Events.

What I am trying to do is if I have a record on the screen i.e. Joe Bloggs and I have the main details and the employment details all present and correct I want to be able to click on a NEW RECORD button on the Episode Tab and it will only clear the Episodes and Events tabs leaving Main details and Employment in tact.

Please help I have been trying to do this for ages with no luck and now time is running out for me to deliver.

Thank you in advance to anyone who can offer any advice

[MMcCarthy]

You need to use subforms for records on the episodes and events tabs. Then you can put a new record button on each of those subforms.