Retreive Query Values in a Listbox

[Ragnar78]

Hy,

I have a combobox that allows me to select the name of a Product...

This product is purchased from diffrent vendors.
My query retreives all the vendors, ordered by vendors status...

I tried RunSQL to retreive the info, it works but it put all the data in a table (INTO)

I was wandering if it was possible to retreive the data (Vendors or selected product) in a LISTBOX

Thx again for the help

 

[Ragnar78]

Ok,
i found a solution for it

launch the query with DoCMD.RunSQL with the "SELECT..INTO nTable..."

Set MyRS = MyDB.OpenRecordset(nTable, dbOpenDynaset) 

With MyRS

While not .EOF
Listbox.Add = nTable!Field()
wend

Docmd.delete nTable

The code is not perfectly writen her, but it sould give an idea