ACCESS FEED: [MS_AccessPros] Opening form so it has the focus

Rabu, 28 September 2011

[MS_AccessPros] Opening form so it has the focus

Good morning! Or whatever it is where you are :-)

Upon clicking a button on Main Menu, the Contacts form is supposed to open with the modal property changed to No. (Form Contacts' modal property is set to yes). When I use the code below the form opens but only its tab shows--Main Menu remains on top.

Thanks!
Connie

On Error GoTo Proc_Err
DoCmd.OpenForm "Contacts"
Forms!Contacts.Modal = False
DoCmd.GoToRecord , , acNewRec

Proc_Exit:
Exit Sub ' or Exit Function
Proc_Err:
MsgBox Err.Description, , _
"ERROR " & Err.Number _
& " btnContacts_Click"
Resume Proc_Exit
'if you want to single-step code to find error, CTRL-Break at MsgBox
'then set this to be the next statement by right-clicking on Resume Statement, then press F8 to execute one line at a time
Resume