inserting records inside subform tab control

[tazardous]

I have a form, let's call it frmMain,
containing a subfrm, let's call it subfrmTabs,
that contains a series of tabs.

When a user clicks on a tab and enters a new record,
I want to be able to set a field in this new record to
the name of the tab they are working in. This way, the
record they add will be associated with that tab and will
only display while that tab is active.

In what event, and what code do I use to do this?

Thanks,
Taz

 

[beetee]

This issue has been dealt with elsewhere

 

[tazardous]

This thread was addressed here:
thread705-482189