[AccessD] How to Use SQL Server Stored Procedure as a Rowsource forListbox

Create a pass-through query that calls the SPROC and use the
pass-through query as the source of your List box.

This link will tell you how to create the pass-through query:

http://support.microsoft.com/kb/303968


Rusty

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Thursday, August 02, 2012 2:57 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Use SQL Server Stored Procedure as a Rowsource
forListbox

I'm lost!
Well actually that's my normal state usually.
I need help...

Everything I've done in the last 3 years has been in Access 2007.  I
haven't touched SQL Server at all for that long.

For a new requirement I need to run a stored procedure (SPROC) and
populate a list box.
The form has two combo boxes that will be the parameters that is passed
to the SPROC.
I have successfully (I think), opened the database, passed the
parameters and run the SPROC.
I can't figure out how to populate the list box.
I'm a pretty simple guy.  The code I got from SQL Server administrator
is 8 pages long... several functions and a class.
That just seems too complicated for this.

The process I'm trying to do is:
Choose the parameters for the first SPROC Execute the SPROC Populate a
list box.  -- this list box will be the parameter for the second SPROC.

What is the simplest way to populate a list box?

Thanks,
Jim
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************