David Emerson
newsgrps at dalyn.co.nz
Tue Oct 4 23:59:18 CDT 2005
Found it - Tools ... Options ... Advanced ... Client server settings ... Default Max Records. I set this to 0. At 5/10/2005, you wrote: >Cross posted to AccessD, AccessDSQL > >Access XP, SQL2K > >I have a combo box that uses the value in the control source to link >to another table and show the description (a typical 2 column combo >box with the first column width set to 0) > >The sproc that is the row source for the combo box returns 16484 >rows. Lately the box has been showing blank even though there is a >valid link to a row in the row source. When I limit the number of >rows the missing text appears. It seems that Access is limiting the >number of rows that are being returned (similar to the Maximum >Records property for a form). > >Is there a similar field for a combo box/stored procedure that will >limit the records returned? > >Regards > >David Emerson >Dalyn Software Ltd >999 Moonshine Rd, RD 1 >Judgeford, Porirua >New Zealand 6006 >Phone 0064 4 235-6782 >Fax 0064 4 235-6783 > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com