warning message box

[mamfa]

how do i get a message box to come up to warn a user that they are about to delete a record? i want them to be able to click ok or cancel so that they can change their mind, do i need to create a form of is there another way?

thanks
Samantha

 

[MyBoo]

How are you allowing the user to Delete?

If you are using a Command Button to Delete the record, then edit the event and add a MsgBox statement.

Dim Response

Response = MsgBox ("Delete?", vbYesNo)
If Response = 6 then
'your delete command goes here
end if

6 = yes
7 = no

Search HELP on MsgBox for additional formatting and options.

 

[SydneyGeek]

Hi mamfa,

Normally, if you try to delete one or more records you will get an automatic warning from Access, with OK and Cancel options. Is this what you wanted, or do you want to replace this with something else?

Denis

 

[mamfa]

hi i like the first idea it suits what i need better however when writing the code when i write the line

6 = yes

it errors and stays red??

am i not getting something

 

[MyBoo]

6 = yes and 7 = no are informational ... not part of the code. Remove