I am having a problem with a combo box in an Access 97 database not displaying all records in the underlying recordset. The application is for problem tracking and resolution and the combo box goes against the user table (tbl_users) and should display all records where the field L_NAME is not equal to a space (“ “). The problem is that when you enter the combo box and click the down arrow to get it to scroll, it only displays part of the records. This behavior is not consistent, sometimes it displays all records from the first down to ‘Mueller’, the next time it will display from the first down to ‘Smith’, the next time records from the first down to ‘Treadway’.

When I go into the combo box’s properties and click the ellipsis (…) next to Row Source and then run the query the datasheet view (correctly) displays all 752 records. In addition, if you start typing a name like ‘Williams’ the name will appear in the combo box but will still not appear if you click the down arrow and try to scroll it. If it helps any the Row Source is: SELECT DISTINCTROW tbl_users.USER_ID, RTrim([L_NAME]) & ", " & RTrim([f_Name]) AS User_Name, tbl_users.PHONE, tbl_users.DIV, tbl_users.SYST FROM tbl_users WHERE (((tbl_users.L_NAME)<>" ")) ORDER BY RTrim([L_NAME]) & ", " & RTrim([f_Name]);

Can anyone offer assistance that will help me make the combo box display all 752 records when scrolling after clicking the down arrow? Any help is appreciated.

I should have guesses the 'code' option would have done that.... sorry.