Form Displaying 1

[quest4]

I open a form, tabular, against a query to display the data, which it is doing quite nicely, with one exception, it is hard to read. The form displays the EmployeeNumber and several fields of data in a row, which is just fine. The problem is I have twenty to fifty of these rows for each EmployeeNUmber and a hundred EmployeeNumber's. Now it would make things alot easier if only the first row EmployeeNumber appeared. This was easy to do in the report version, which allows me to group by the EmployeeNumber. Anyway of getting the duplicate EmployeeNumber to stop displaying? Thanks a million in advance.

 

[930driver]

You should probably have your current form be a subform of a employee form. Then the employee information (ie. number) could be on the main form and the related information on the tabular subform. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[quest4]

I guess it is working, I was hoping to do a little more with it and that is why I was going to use a separate form. Thanks a million.