Max Number Records In Combo Box

[bradmaunsell]

Access 2003
SQL 2005 Express
Windows XP

I have a problem with the number of records being displayed in a combo box.

I am using the following stored prrocedure as the ROWSOURCE for my combo box.

============================================================

USE [MGA]
GO
/****** Object: StoredProcedure [dbo].[sp_SELECT_APP_ByAppID] Script Date: 08/23/2007 10:54:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[sp_SELECT_APP_ByAppID]
AS
BEGIN

SELECT TOP (100) PERCENT dbo.tblApps.AppID, dbo.tblPolicyholders.NamedInsured1, dbo.tblApps.AppDate_Recd
FROM dbo.tblApps LEFT OUTER JOIN
dbo.tblPolicyholders ON dbo.tblApps.ProducerID = dbo.tblPolicyholders.PolicyHolderID LEFT OUTER JOIN
dbo.tblBoundPolicies ON dbo.tblApps.AppID = dbo.tblBoundPolicies.AppID

ORDER BY dbo.tblApps.AppID DESC
END

============================================================

The stored procedure returns 13433 records when run in the SQL 2005 Express management console.

In Access, it will not return all records. I tried selecting RECORDS on the top menu and setting to zero to return all records but nithing changes.

I need to return all records when the user clicks the combo box.

What am I doing wrong?

Thanks,
Brad

 

[bradmaunsell]

Ooops!

After hours of searching, I discovered a SECOND "number of records" setting under TOOLS > OPTIONS. One is for the database and one is for edits.

Works OK after setting correctly!

Brad