how to create message box when in vb.net after click the button such as delete?

[mrijet]

Dim sql as string

sql = "DELETE * FROM tablename WHERE fieldname = YES"
docmd.runsql sql

end sub

how to create statement if or else if...if the user choose not to delete the data?

[samvb]

Why not use dialogresult enum?