recordsource in form's combo box

[SoxPats83]

i have a unique one here. i would like to create a combo box on my main form that contains all of the tables and queries available in the DB so the user can change the recordsource.

i have a particular form where the recordsource changes daily, and i would like to have this combo box so even the most novice Access user can use this form without have to mess around with design view.

any thoughts?

 

[vbaInet]

Have a look at this thread and the links within it too

 

[SoxPats83]

i appreciate the reply, but in yoru attached link, i fail to see where i would be able to create a combo box with all tables/queries listed in the drop down? i am sure it is all there, i am just missing it...

 

[vbaInet]

The idea was there all you had to do was to utilise it

SELECT MsysObjects.Name, IIf([Type]=5,"Query","Form") AS Object_Type
FROM MsysObjects
WHERE (((Left([Name],1))<>"~") AND ((MsysObjects.Type)=-32758 Or (MsysObjects.Type)=5))
ORDER BY MsysObjects.Name;

Create another query based on the above and sort by Object_Type followed by Name.