Hi All.
I've seen posts that had some information about this, but I just can't seem to put it together.
I have an Access 03 database. I want to fill a multi-column listbox with the results from a stored procedure on SQL 2005 server. The stored procedure requires 2 numeric parameters. It returns 5 columns of text data.
The sp works in SQL Management Studio and I can get data if I build a Pass-Thru query in Access (via the designer). I want to code this to re-fill the listbox based on the selection from another listbox.
I thought it would be as easy as:
Me.List1.RowSource = "Exec sp_QView1 1234, 2" - but that doesn't return anything, no error either.
I'm a beginner, I've tried to adapt about 20 code clips from all over the web but can't get anything to work. Can someone please just give me a simple example of how to do this?
Thanks in advance.