Link to home
Start Free TrialLog in
Avatar of J G
J G

asked on

VBA cmd for button click in a access form

What is the  vba function/procedure in Access that will pass through a button click on a form?
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of J G
J G

ASKER

The example above did not work.  Below is code I am using for my form.  I want to add the click button in the else statement.  

Function Message()
Dim MSGBOXRSP As Integer

MSGBOXRSP = MsgBox("                    Not Found.  Add new item?", vbOKCancel)

If LResponse = vbOK Then
  ' {me.SearchField=null}
Else
   [Forms]!Item_Master.SearchField = Null


End If
End Function
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Can you describe more precisely what you are trying to do here?