Unusual combo box problem

[wh00t]

I have a combo box on a form using the following row source

SELECT DISTINCTROW [tblVanOrders].[OrderID], [tblVanOrders].[OrderNumber] FROM [tblVanOrders];

OrderID is an autonumber field in the table and OrderNumber is a number field, the table contains 21745 records.

The problem I'm having, is that the combo box does not list all the records in the table, it also does not cut off at a certain point, it appears that random chunks from the table are missing. I have checked the table, and all records are in the correct format. is there something I'm missing or shall I just use a standard find record button?

 

[dcx693]

Your combo box might not be loading all the data since your rowsource is large. Follow the instructions at this thread: Load combo box data faster? and see if that helps.

Also, you might also want to sort your combo box data.