Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > Msgbox question
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 41547 of 43412
Post > Topic >>

Msgbox question

by "rebecky via AccessMonster.com" <u40765@[EMAIL PROTECTED] > Aug 7, 2008 at 05:10 PM

This seems like such a simple, basic thing, but I cannot get it quite
right.
I have an employer form(main form) with a position posting(subform).  I
have
added a "cut" command button and just want it to display a msgbox telling
the
user that if he/she is in the main form, he/she must use the "cut" button
on
THAT form........otherwise the error msgbox will say "Nothing to cut!"
What have I done wrong?


On Error GoTo Err_Command241_Click

Screen.PreviousControl.SetFocus
RunCommand acCmdCut

    
Exit_Command241_Click:
    Exit Sub
    
Err_Command241_Click:
 If Screen.ActiveForm.Name = "EmployerPositions1" Then

    MsgBox "You Must Use the Employer Cut Button to Cut Employer
Information"
    
  Else
  
  MsgBox "Nothing to Cut!"
  End If
  
    Resume Exit_Command241_Click

Exit Sub

End Sub

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200808/1
 




 2 Posts in Topic:
Msgbox question
"rebecky via AccessM  2008-08-07 17:10:53 
Re: Msgbox question
"Albert D. Kallal&qu  2008-08-08 00:58:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:45:07 CST 2008.