open for in Front End

[Georges]

Hello,

In my application I have a form which will be the menu it
contains bottoms to open all the forms of the application
I want when I click at any bottom the form will open but
the menuForm will stay at the Back of any form I'll open
is it possible in VBA

This is my code to open a Form from my FormMenu

Private Sub cmdClient_Click()
On Error GoTo Err_cmdClient_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FrmClient"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdClient_Click:
Exit Sub

Err_cmdClient_Click:
MsgBox Err.Description
Resume Exit_cmdClient_Click


End Sub

 

[Dirk Goldgar]

Hello,

In my application I have a form which will be the menu it
contains bottoms to open all the forms of the application
I want when I click at any bottom the form will open but
the menuForm will stay at the Back of any form I'll open
is it possible in VBA

This is my code to open a Form from my FormMenu

Private Sub cmdClient_Click()
On Error GoTo Err_cmdClient_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FrmClient"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdClient_Click:
Exit Sub

Err_cmdClient_Click:
MsgBox Err.Description
Resume Exit_cmdClient_Click


End Sub

There is nothing in that code that would close your menu form, so it
should behave as you ask. If it doesn't, it could be because

(a) there is code in the opened form that closes the menu form, or

(b) the menu form has its PopUp property set to Yes.