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

Charlotte E.[_2_]

Try this:

If MsgBox("This will delete all information on this caller" & vbLf & "Are
you sure you want to do this", vbYesNo) = vbYes then
Me.FirstName.Value = ""
Me.LastName.Value = ""
Me.Caller.Value = ""
Else
Exit Sub
End If

Dave wrote:
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

Dave[_9_]

Thank you.

That did the trick

Dave

"Charlotte E." <@ wrote in message
...
Try this:

If MsgBox("This will delete all information on this caller" & vbLf & "Are
you sure you want to do this", vbYesNo) = vbYes then
Me.FirstName.Value = ""
Me.LastName.Value = ""
Me.Caller.Value = ""
Else
Exit Sub
End If

Dave wrote:
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
Linear Mode Switch to Hybrid Mode Switch to 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