About Us

Dave[_9_]

seems I can't get an IF statement based upon the response from a msgbox
function

This is what I have

Code:

        MsgBox "This will delete all information on this caller" & vbLf & _
    "Are you sure you want to do this", vbYesNo
    If vbYesNo = Yes Then
        Me.FirstName.Value = ""
        Me.LastName.Value = ""
        Me.Caller.Value = ""

      Else
        Exit Sub
      End If
    Me.Status = 4
    DoCmd.Close

If I hit YES it does not delete the info.

should the IF statement be true/false or 0/1 instead of Yes/No?

Is the MsgBox written wrong?

Any help here will be appreciated.

Thanks in advance
dave

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If statment	Cerealkiller via OfficeKB.com	Excel Discussion (Misc queries)	5	May 28th 10 10:09 PM
if statment	Stuntz Waldorf	Excel Worksheet Functions	4	June 24th 09 08:07 PM
IF Statment	Momo	Excel Worksheet Functions	2	December 6th 08 02:24 PM
Help with If statment	pm	Excel Discussion (Misc queries)	3	January 29th 08 04:09 PM
if statment	Dreamstar_1961	Excel Worksheet Functions	5	April 17th 07 01:30 PM

Menu

About Us