DoMenuItem

[Informatic]

I have used the following VBA Code to find a record in a form :

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Can i ask with VBA Code if the DoMenuItem form is closed be the user or still not.

Help...

 

[nabiS2K]

Informatic,

You would need to this:

Dim frm As Form
Dim frmIsOpen As Boolean

For Each frm in Forms
    If frm.Name = "MyFormsName" Then frmIsOpen = True
Next frm

If frmIsOpen = True Then
    '<List of commands if form is already open>
Else
    '<List of commands if form is closed>
End If

You will need to change MyFormsName to the actual name of your form. Then you would just need to replace the two sections in the If...Then statement to whatever you like. God Bless,
Mike

Yes, I believe in Jesus. ;-)
"Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved." (Acts 4:12, KJV)