Caution, this will also display subforms. If you are attempting to provide application navigation functionality, I would take the time to create a table of form names and their friendier titles. I wouldn't want to expose my form names to users since they really aren't named for "human consumption".
[blue]Remou[/blue] has posted what you need, however [blue]dhookom[/blue] makes a good point in that subforms also show.
If you desire to [blue]exclude subforms[/blue] and in your naming convention you've prefixed or postfixed a common descriptor (say [purple]sfrm[/purple] as in [purple]sfrm[/purple]ClientDetails), then a [blue]Where[/blue] clause appended to [blue]Remou's[/blue] code will do the trick. Example:
Code:
[blue]SELECT Name
FROM MsysObjects
WHERE ((Left([Name],4)<>"[purple][b]sfrm[/b][/purple]") AND (Type=-32768))
ORDER BY Name;[/blue]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.