Remember where a form was opened from

[RandyMyers]

Hello All,

I have a different situation. I have a very involved form that has many popup links and other forms can be opened from within it. This form can be opened from a main menu, labeled as create a new record, or from a seperate form that is displaying a list of records that were resulting from a data search.

The idea is that I want to have the application remember where it was opened from because the closing actions would differ and I would also want to be able to return to the "searched list".

I know I could make a duplication of this form and just open the alternative version from the "search list", however this will get very complicated because 10-15 fields can be double clicked to open popup forms. This would require duplicating these popups, etc. and could get messy. Also, any modifications needed in the future would have to be duplicated.

Anyone have an idea of how to build a function (or any other method) to track where the form was opened from and to be able to return to the calling form?

Thanks in advance for any idea.

 

[Lightning]

I had a similar problem recently where a couple of forms could be opened either from a switchboard, a search form or a data entry form. I used the IsLoaded function in a Select Case statement to see which form was open. Part of that solution was also to ensure that I had the Cases in the correct order, because some forms could only be opened from other forms.

HTH
Lightning

 

[MichaelRed]

Aalthoough a bit of work, you could easily include the calling objects' name as an "OpenArg". It is easily found in ye olde ubiquitous {F1}, and there you might also see some additional info on how to ...





MichaelRed