Navigation bar

[am_sarath]

Hello

I need to have a navigation bar in my forms.

For example: when we click on favourites(tool bar) in internet explorer, we get all the list of favourites stored on the left side of the screen and from there we can connect to our favourite webpage.I need to have such system implemented in my form.
I have set of forms and I need to have a tool bar "Navigate" displayed when I open a form and when I click on that I should get all the forms stored in my database displayed on the left side, as exactly how it shows in the internet explorer and it when i click on any form, i should get connected to that.

Could some body please help me regarding this.

Thanking in advance.

 

[Fornatian]

Use a list box to hold the list of forms in the database. Set the rowsource to this SQL...


SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32768));

-32768 returns only object of type form.

I would suggest a button rather than clicking a row in the listbox, as clicking inadvertantly in the listbox could be very annoying.

Anyway, the code you would use to open the related form is:

Docmd.OpenForm Me.ListBoxName

Ensuring that the bound column of the list box is set to 0(zero) this will work.

Ian