Hide cmdbutton when opening frm in add mode

[mtagliaferri]

the forms open correctly in add more without the edit button as in pic3, but it will not open when it is clicked from the frmMain which the form containing the code is inserted in as in pic2 of previous post.
Is this what you wanted to know or am I misunderstanding your question?

 

[GinaWhipp]

I thought you were saying you were opening the continuous form when trying to add new... but that was me misunderstanding.

Going to have some coffee and re-read...

 

[GinaWhipp]

Try...

 Private Sub CmdAdd_Click()
   DoCmd.OpenForm "frmAirport", acNormal, , , acFormAdd
   Forms!frmAirport.CmdEdit.Visible = False
End Sub

 

[mtagliaferri]

I believe the form opens correctly but it stays behind the frmMain, which I don't understand why as I have other forms that I open and the open on top of frmMain and there are no event for the open frm

 

[GinaWhipp]

Are the other Forms opening in Pop-up mode?

 

[mtagliaferri]

All forms have PopUp and Modal set to NO

 

[GinaWhipp]

Hmm, that is odd, usually that is the reason. Is there any other code that would snatch the focus away from the pop-up? Something different from where you are opening it?

 

[mtagliaferri]

I have seem to have solved the issue by changing the PopUp to Yes and added the following code

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
stDocName = "frmAirport"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

Any implications on doing that? can you also tell me what exactly the modal options is?

 

[GinaWhipp]

I don't see any issues setting it o PopUp, just glad it's finally working!

Modal...
The Form pulls all the focus to itself, see...
https://msdn.microsoft.com/en-us/library/office/aa172748(v=office.11).aspx