Forms Navigation bar

[am_sarath]

Hello
I would like to put up a navigation bar in all my forms, like-when i open any form, i should get the list of all forms in my dB and when i click on any form, the control should get transfered to any form.How can i implement this?anz suggestions pls.

 

[Jack Cowley]

Put a combo box on your form(s) with this as the Row Source :

SELECT [MSysObjects].[Name] FROM MSysObjects WHERE (Left([Name],1)<>"~") And ([MSysObjects].[Type])=-32768 ORDER BY [MSysObjects].[Name];

In the after update event put this:

DoCmd.OpenForm Me.ComboBoxName