Upgrade a Combobox with queries list in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(Transferring question from VSTO Forum on behalf of Steve Bak)

Hi,

This is what I'm trying to do with Access 2000 :
In a Form called 'MENU REQUETES', I want to upgrade my combobox 'Req_Liste'
with the name of all the queries present on my database.

I tried this :
Set dbs = Application.CurrentData
For Each obj In dbs.AllQueries
Forms![MENU REQUETES]![Req_Liste].additem obj.Name
Next obj

but this is not working....can someone help me ?

Thanks
 
Req_Liste.RowSource = "SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=5) AND ((MSysObjects.Flags)<>3));"

n = req_list.listcount

(david)
 
Back
Top