Populating a listbox from a parameterized query

[mcalex]

Hi, I'm having trouble trying to populate a list box with data from a parameterized query.

If I set the rowsource property to the query name, when the form opens I get the parameter values dialog, but I want to pass the params from code.

If I create a querydef, I can pass the parameter in, but I don't know how to get the records into the listbox. I have tried

lstNames = qdfNames.sql

lstNames.recordset = qdfNames.OpenRecordset;

rstNames = qdfNames.OpenRecordset
lstNames = recordSetNames.getRows;

I feel like i'm doing something stupid, coz this should be easy, but I'm too new to access to know all its tricks.

can anyone point me in the right direction?

cheers

[MikeTheBike]

@mcalex
Hi
You have not indicated where/how you are setting the parameters/variable(s) in code, but pehaps you could try something like this

lstNames.RowSource = "SELECT * FROM qryName WHERE FieldName = " & CodeVariable 
lstNames.Requery

where qryName is the name of the stored querydef which should not have any perameters that you want to set in code.

??


MTB

[mcalex]

Hi Mike

I was doing something stupid. I hadn't set the RowSourceType property. It seems that as well as the RowSource, access needs to know the type before it will display data in a listbox.

As soon as I added:

lstNames.RowSourceType = "Table/Query"

it all worked, and nearly exactly how I expected :-)

cheers