Tab Controls

[Nick]

I have integrated tab controls in one of my forms. Two subforms are on each
tab. I would like to be able to not allow users to add a record if fields
on multiple tabs are populated (i.e. if the appropriate fields on Tab 1 have
been populated, the fields on tabs 2 and 3 must remain blank). Could
someone please help me with this logic?

Thanks in advance for your help. Please let me know if you have any
questions.

Nick

 

[John Smith]

I would suggest, in the exit event of the subform control, check if data has
been entered, (probably by RecordsetClone.RecordCount > 0) and if so disable
the controls on the other tabs. You could hide the other tabs entirely, but
that might confuse your users!

If record navigation is possible on the main form you will need to duplicate
the code in the Form current event to ensure that each record is appropriately
locked.