Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure and List Box

Status
Not open for further replies.
pcdaveh

pcdaveh

Technical User
Sep 26, 2000
213
US
Does any one know how to call a stored procedure and have it populate a listbox on an Access Form. The sp is already created with input variables. I don't know if I need to use declare a cursor or output variable and then how to get those row into the listbox. Anyone have a clue or an example?
 
Sort by date Sort by votes
If the stored procedure does not require parameters then you can enter as the row source of the Combo/Listbox. I have not found a way to easily enter the paramters. See this thread for a workaround. thread701-457149
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dw134
  • Locked
  • Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
252
dw134
dw134
batteam
  • Locked
  • Question
MS Access 2013 and Stored Procedures
Replies
1
Views
186
lameid
lameid
toptech
  • Locked
  • Question
How do I pass form field into criteria of stored procedure
Replies
2
Views
170
toptech
toptech
GShen
  • Locked
  • Question
docmd.transfertext using a stored procedure or query in an adp.
Replies
2
Views
112
GShen
GShen
sparkbyte
  • Locked
  • Question
pass param into stored procedure
Replies
1
Views
76
danvlas
danvlas

Part and Inventory Search

Sponsor

Back
Top