Help with Combo box list to retrieve queries or forms lordjeffj 06.07.2006 21:32:01 Hello, Could someone tell me how I can list the queries of an access database in a combo box in my access form? Jeff

Re: Help with Combo box list to retrieve queries or forms fredg <fgutkind[ at ]example.invalid> 07.07.2006 01:31:15 On Thu, 6 Jul 2006 14:32:01 -0700, lordjeffj wrote: [Quoted Text] > Hello, > > Could someone tell me how I can list the queries of an access database in a > combo box in my access form? > > Jeff Set the Rowsource Type property of the combo box to Table/Query. Set the row source to: SELECT MSysObjects.Name FROM MSysObjects WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY MSysObjects.Name; -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail