Navigation

[a.phillips]

I have wrote up an example of the problem I am having:

The following forms are on the database:
Frm_Main_Menu
Frm_Search_Customer
Frm_Customer_Details
Frm_Add/edit_Customer_Details

From the form Frm_Main_Menu there are links to, the form Frm_Search_Customer, and to the form Frm_Customer_Details.

On the from Frm_Search_Customer and Frm_Customer_Details, there is a link to the form Frm_Add/Edit.

On the form Frm_Add/Edit, there is a link back to where they came from, which could either be the Frm_Search_Customer or Frm_Customer_Details.

Is there anyway of programming a button to remember where the user has came from so it can navigate the user back to the form they were on?

I have tried to be as clear as possible but if there is any other bits of information what you need please ask (also using access 97).

Thanks.

 

[spikepl]

If your Frm_add/Edt is made (or opened as) modal, then the user will be returned to the calling form when you close it

 

[SteveH2508]

I use a Global variable to track which form opened which other form and then use that in the close event to go back to the previous form, HTH.

 

[Gnasch]

The simplist way would be to pass a form object to the Frm_Add/Edit that is set to the calling form. This way you can do any recordset or control manipulation you need to do from the Frm_Add/Edit and dont need to worry about which form called.

 

[a.phillips]

Thanks for the help