msgbox show client name selected for deletion

L

Liz James

I have code to pop up a confirmation message when user is about to delete a
client name from a form in continuous view.

How can I code the message to say “Confirm deletion of client **client first
name client last name** ?

How do you get the name of the client from the selected record into the
message that pops up?

All suggestions greatly appreciated.
 
F

fredg

I have code to pop up a confirmation message when user is about to delete a
client name from a form in continuous view.

How can I code the message to say ´Confirm deletion of client **client first
name client last name** ?

How do you get the name of the client from the selected record into the
message that pops up?

All suggestions greatly appreciated.
Click to expand...

If MsgBox ("Confirm deletion of client " & [ClientFirstName] & " " &
[ClientLastName] , vbExclamation + vbYesNo) = vbYes then
' Delete OK code here
Else
' Dont delete code here
End If
 
Top