Purely advice needed

[despatcher]

What i have!

Employee table 60+ columns each one a specific employee qualification these are all set to Yes/No (Tick boxes).

I want (would like) all these on one form if possible.

The form as you can imagine looks ridiculously cluttered.

What i have tried!

Created lots of forms incorporated these into one form as tabs/subforms looks ok but seems very easy to enter data three or four tabs down but it actually be for the wrong employee.

What i would like but can't seem to get right

A lot of the qualifications fall into there own sub categories can i put these into a drop down list box specific to category (multi select or yes/no enabled,) combo box or something.

Any advice would be great i cannot see the wood for the trees at the minute

 

[CEH]

First thing I would check is normalization..... Should this really be only one table? Maybe......
One thing comes to mind for your tabs... to make sure you are on the correct record you can put an unbound textbox on each tab... even use the same color background so it does not look like a textbox... make this text box control source your Employee name......

 

[missinglinq]

Since you already have a problem with crowding, here's something I use on forms with tagged pages:

Private Sub Form_Current()
   Me.Caption = "Active Employee Record for:   " & EmployeeName 
End Sub

This means you can always tell which employee you're working with by glancing at the title bar.