form navigation

[nitya]

i have a project with 4 forms. i want to go to various other forms from the current form. how can i do it?

thanks

[RuralGuy]

Use code to set the Focus to a different Form using the Forms collection.

[nitya]

Use code to set the Focus to a different Form using the Forms collection.

thanks for your reply.

but i'm new to access and i would like a detail on the procedure to do what you suggested..

thanks in advance.

[Bob Fitz]

You could use the wizard to create an "Open Form" button for each of the forms.

[RuralGuy]

And here's the syntax for referring to forms: http://access.mvps.org/access/forms/frm0031.htm

[Bob Fitz]

Another way it could be done:
Instead of four buttons, have one combo box. Set it's Row Source Type property to: Value List.
Set it's Row Source property to: "NameOfForm1";"NameOfForm2";"NameOfForm3";"NameOfF orm4";
Replace "NameOfForm1" etc with the names of your forms.
Put the following line of code in it's After Update event

  DoCmd.OpenForm Me.ActiveControl