David Emerson
newsgrps at dalyn.co.nz
Tue Oct 4 22:21:59 CDT 2005
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