J G
asked on
message box formulas
I am using the following message box code. .
If OK, I want to open a subform.
If Cancel, I want to insert a null value into a text box, and click on a form button
Could you tell me the code I need to insert into the VBA below:
Select Case MsgBox("Item Not Found. Add new item?", vbOKCancel, "Missing Data")
Case vbOK:
'code
Case Else
'code
End Select
If OK, I want to open a subform.
If Cancel, I want to insert a null value into a text box, and click on a form button
Could you tell me the code I need to insert into the VBA below:
Select Case MsgBox("Item Not Found. Add new item?", vbOKCancel, "Missing Data")
Case vbOK:
'code
Case Else
'code
End Select
ASKER
When I compile the code I get the following error:
Compile Error:
Invalid Use of the ME Keyword
Compile Error:
Invalid Use of the ME Keyword
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Call cmdYourCommandButtonsName_