troubleshooting Question

Deleting current record

Avatar of bobby6055
bobby6055 asked on
Microsoft ApplicationsMicrosoft Access
5 Comments1 Solution421 ViewsLast Modified:
I have tried several onclick delete code. Now I want to try something new using some conditions as follows.

Perform delete action in the Edit or newRecord mode with the following defined conditions.

(a). If "IsNull or nothing" in text1(currentscreen), or text2(currentscreen)  or text3(currentscreen),
         then msgbox "Nothing to delete.

       Else....

(b). If "Not Is Null" text1(currentscreen), or text2(currentscreen)  or text3(currentscreen),
       Then msgbox "Are you sure you want to delete the current record #111 (for example)

      If User Response is "Yes" then perform the delete action for record id #111
      If User Response is "No" then do not perform the delete action for record id #111

 
ASKER CERTIFIED SOLUTION
Lambert Heenan
The Man

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros