Good day

I have created a workbook that a user can maintain staff leave. I need
help with two thing.

1. I want to be able to restrict to unique records. For example if an
employee with the #87 is created and the user tries to create another
employee with the same #, then the program should inform them that that
# is already in use, so they should try a new #.

2. I have included an MSFlexGrid to one of my forms to display unique
employee data. I want the program to search the sheet to find the
employee # and all the data related to that employee and dislpay it in
the FlexGrid.

The problem is that I don't see a DataSource property for the FlexGrid.
How do I go about displaying this data in the grid?

Thanks for all your help

Kind Regards


--
poppy
------------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453
View this thread: http://www.excelforum.com/showthread...hreadid=551824