View Full Version : Forms Navigation bar


am_sarath
02-09-2002, 03:24 PM
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
02-09-2002, 07:38 PM
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