Maximum Records for Combo Box

[MelissaKT]

I use a combo box to help locate records on an unbound form. The combo box is based on a stored procedure that has over 40,000 records. I have set the maximum records for the stored procedure to 0 but can't get the combo box to show all of the records. I'm sure that I'm just overlooking something....

HELP!!

Thank you in advance.

 

[PWise]

I have set the maximum records for the stored procedure to 0

where have you set this

 

[MelissaKT]

I opened the stored procedure to show all of the records, then clicked on records -- Maximum Records. Then I saved the changes.