First Form disappears when second form called

[Nadine67]

Hello and thank you for any attention my post may receive.

Windows XP
MS Access 2007

So when i call up two forms, the first called form disappears. I want both forms to appear on the screen at the same time.

My module 'modDaisyChain' returns an 'Outside procedure' error for 'Me.' I understand Me is not allowed in a module, but I really do not know what i should be using in this instance.

Any help is greatly appreciated!


Public gstrCallingForm As String
Const DAISY_CHAIN_ON As Boolean = False '(True for on, False for off)
Dim mstrCallingForm As String

gstrCallingForm = Me.Name
Me.Visible = False


Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

If DAISY_CHAIN_ON Then
'set calling form
mstrCallingForm = gstrCallingForm
gstrCallingForm = ""
End If



Exit_Form_Open:
Exit Sub

Err_Form_Open:

Resume Exit_Form_Open

End Sub


Private Sub Form_Close()
On Error GoTo Err_Form_Close

If DAISY_CHAIN_ON Then
'return to calling form
If mstrCallingForm <> "" Then
Forms(mstrCallingForm).Visible = True
End If
End If

Exit_Form_Close:
Exit Sub

Err_Form_Close:
If Err = 2450 Then
'ignore error if calling form is no longer loaded
Resume Next
Else

Resume Exit_Form_Close
Resume
End If
End Sub

[June7]

These two lines are not within a procedure. Compiler should error because of that. Shouldn't they be in some form Open event, maybe the calling form?

gstrCallingForm = Me.Name
Me.Visible = False

DAISY_CHAIN_ON is declared as a constant with value False. It can never be True.

Don't really understand what this code in form Open and Close events is supposed to accomplish. Where did you find this code?

[CJ_London]

So when i call up two forms, the first called form disappears. I want both forms to appear on the screen at the same time.

In file>options>current database>Application Options -tick overlapping windows

Unfortunately I've no idea what your code is supposed to do

[Nadine67]

Hi there June
I found this code online from www.experts-exchange.com I found it when i googled 'modal forms disappearing behind other modal forms'.

Hmmmm I will scrap the code, although I still want both my forms to appear on the screen at the same time. Really have no idea how to accomplish this.



Hi Ajax
Thank you, but 'overlapping windows' is ticked and still no joy.

Cheers

Nadine

[CJ_London]

In that case, one form is presumably hiding the other. Dragging the one you can see over to one side should expose the other.

Also ensure that the form auto centre property is set to no

You can look at using the move function to position the form exactly where you want it.

Another option might be to have a third form with the other two forms on it as subforms

[Nadine67]

Hi Ajax

The thing is the database opens with a control panel where the user selects various options. And it is behind the cotrol panel the first form hides whent he second form is called.

Perhaps a sub-form is the way to go.

Thanks for your help and have a great day!

Nadine

[Nadine67]

Guess what? I had my 'control panel' pop-up property set to 'Yes'. Now that it is set to 'No' I am able to view both forms at the same time.

Thanks June and Ajax for asking the questions you did for it allowed me to see beyond the 'I'm stumped' cloud and think about it.

Happy days

Nadine