On Click - from another form

  • Thread starter Thread starter יריב החביב
  • Start date Start date
×

יריב החביב

Hello,

We have a form with a lot of command button's

one of them is to dellete data from table.

we want that when runing this command (before the dellet will run)

a form with a warning will open who will ask "are you sure . . . ?" .

so we have this form

but we dont know how to activate the delete comand on

the basic form, in case the user click "yes" from the warning form .

thank you for your help
 
THANK YOU
--
תודה רבה


bhicks11 via AccessMonster.com said:
Here's an example from one of my apps:

DoCmd.OpenQuery MQRY

x = MsgBox(" Delete " & UCase(MLIST) & "?", vbOKCancel)
If x <> vbOK Then
x = MsgBox("Delete Cancelled!")
Exit Function
Else
GoTo GoAhead
End If



GoAhead:

DoCmd. - run your delete query here

Bonnie
http://www.dataplus-svc.com

יריב החביב said:
V B A
Are you doing it with a macro or VBA?
[quoted text clipped - 18 lines]
thank you for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top