Combo Box in Access 2013 that looks up to reports
I m designing an access database and on my start up form it gives them a list of options of what they would like to do, with command buttons.
I am having trouble however with a combo box that has a list of the available reports in the database and then obviously bring up the reports so they can print them. i have managed to bring up the lit of reports from my database but when you click on the selection it does nothing?
i have looked at some solutions posted on this website for older versions of access and the codes don't appear to work.
i have this in the row source of the combo box;
SELECT [Name] FROM MsysObjects WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*")) ORDER BY [Name];
I think i need to put something in the event of the combo box but anything i put in there doesn't work?!
Any help and advice would be appreciated.