asked on MS Access Listbox Context Menu
On my listbox I would like to add a function to the Right Mouse Click.
Essentially I was it to say..."Remove Client from Visit"
On click run a Sub.
Essentially I was it to say..."Remove Client from Visit"
On click run a Sub.
Microsoft AccessMicrosoft DevelopmentMicrosoft Applications
Last Comment
Larry Brister
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
"Not sure about right-clicks in Access 2007/2010."
?
?
Right clicks (shortcut menus) are not a problem in 2007, but have not tested with a 2010 listbox.
All MenuBars (Menus, Toolbars & Right Click) port over to A2010 from A2003.
mx
mx
ASKER
Sorry for late get back.
Tested both answers.
Thanks
Tested both answers.
Thanks
Why not just put this on a button?
So the user could just select the Record from the listbox, then click the button to "remove"...
The code would be something like this regardless:
Dim strSQL as string
strSQL ="DELETE * FROM YourTable WHERE ClientID=" & lstClient
Currentdb.execute strSQL, dbfailonerror
me.lstClient.requery
JeffCoachman