Replace a form in unbound field

[mtagliaferri]

Hi all, I am pushing my luck with my limited knowledge, I have a form with a navigational control which loads in the unbound area a form according to the navigational btn, this form has a list of records in datasheet view, when clicking on a specific records it opens a form with the specific record selected, I would, once double clicked on the record, the form to open within the same unbound window.
To be more precise, from the attachment, when the frmMain is open and the user double clicks on the IATACode the navigation target under the Tab Airport closes the form "frmQueryAirport" and opens "frmAirport", once the user closes the window with the appropriate Exit Btn, the "frmQueryAirport" reopens.
Hope this make sense.......

 

[GohDiamond]

Why use an unbound field?

Make two forms the same size and open them at the same position with the FORM ON_Open Event and <code> docmd.movesize.

Clicking on the button on the first form will POPUP(= YES) the second form in the same position and cover up the first form which makes it look like it closed.

Then double-clicking to close the second form will reveal the first form making it look like it opened again.

Same visualization AND the First form is still in it's previous state.

Cheers!
Goh

 

[mtagliaferri]

Hi Goh, thanks for the info I will consider the option, however I will loose the practicality that I am trying to achieve through the tabs, basically if on the first tab I have a list of records by double cliking and opening the record under the same tab I can switch between tabs having the detailed information there handy; if I adopt your solution I will have to close the record or by switching between tabs I will still have the form open above.
Hope you understand the issue, any solutions?

 

[GohDiamond]

I'll take a look at the uploaded database when I get to my home computer.
Goh

 

[mtagliaferri]

Thanks very much Goh!!

 

[mtagliaferri]

I have looked into it, and rather than closing the current form in the unbound window and opening the new form in the same window a better solution would be when double clicking on a record the selected record would load in one of the unbound frm on a different tab, change the setting of that tab to visible, and when the record is closed will set the tab to non visible and select the original tab with the list of records.