Subform

[jPhoenix]

I have a main form (requests) that will have 4 check boxes (EMP; EDU; PRREF; PERREF; LICEN). If EMP is checked, I need the subform EMP to appear. After adding information into that subform I need to close this subform and then open the next (if any others are checked). After all data entry is done, have all subforms disappear again.

[June7]

How to program turning subform off is the trick. When will you know the user is finished entering data? How do these check boxes get checked? Are they bound to fields of table and the checks were previously entered? Instead of all this on/off, consider a tab control. Put each form on a separate tab. User goes to whatever tab is necessary to perform data entry.

[jPhoenix]

works better. thanks!