Combo Box not displaying all rows

Hi - I'm using Access 2000. I have a combo box with 4 columns based on
a query with 4 columns. The query has 111 records. The combo box will
only display 11. When I had 3 columns, it displayed all records. When I
added the 4th column, it initially displayed 17 records. I made a
change to the query, and now it only shows 10 of the records. I've
compacted and repaired without any change. I tried recreating the combo
box using the wizard, and I'm now back to 17 records...

Any suggestions?

re: Combo Box not displaying all rows

Just wanted to add that if I change the combo box back to 3 columns, it
works fine.

Col wrote:

re: Combo Box not displaying all rows

Can you give more detail, the sql from the query would be helpful.

Might have something to do with the SELECT, SELECT DISTINCT , or SELECT
DISTINCTROW part of the query, or the grouping but without more detail
I cannot tell, I doubt that anyone else can either.

Good luck

Nick


Col wrote:

re: Combo Box not displaying all rows

Hi - is this what you are looking for..?

SELECT [EENames].[EEID], [EENames].[LastName], [EENames].[FirstName],
[EENames].[DateEntered] FROM EENames;


Nick 'The Database Guy' wrote: