Forms Menu in a Combobox

[hassanlabban]

Dear Friends
i was wondering if there is a way to make the forms and reports i have in my database show in a combobox where i can choose which form to use same as queries names in a combobox?
if yes, i appreciate letting me the way to do it.

Thanks

 

[Gasman]

One way wold be to create a table that holds
Object Name
Object Type
Description

Then present them in the Combo box.?

Another would be walk through a system table, but then I believe you would be stuck using the object names which might not be that descriptive?

 

[hassanlabban]

Dear Gasman
If we went that way, how to link the forms to the entries in the table?

thanks

 

[isladogs]

Hi

The best way to get the data is using the hidden system table MSysObjects

Have a look at this post which creates a list of all database objects or just forms etc..

https://www.access-programmers.co.uk/forums/showpost.php?p=1545048&postcount=7

It uses a listbox rather than a combo box so you can see more items at once but you could adapt to combo box if preferred

 

[Gasman]

You would use
Docmd.OpenForm Me.cboObjectName.Column(0) (if the object name is the first field in the combo rowsource)

where the first field (objectname) would be hidden and you show the descriptive name.
You could then add option for Arguments to the OpenForm in the table as well?