kingsgambit
Registered User.
- Local time
- Today, 15:37
- Joined
- May 27, 2001
- Messages
- 134
When i delete a record from a sub form on my main form, can you have the message say which record is being deleted i.e are yousure you what to delete item no 123
custom delete message
- Thread starter kingsgambit
- Start date
Jack Cowley
Registered User.
- Local time
- Today, 15:37
- Joined
- Aug 7, 2000
- Messages
- 2,639
This should do the trick:
Dim StdResponse As Integer
StdResponse = MsgBox("You are deleting Record No " & Me.RecordID & " Are you sure", 0 + 4 + 256, "")
If StdResponse = vbYes Then
...delete code here...
Else '(Default)
... do nothing...
End If
Change RecordID for the name of your control that has the unique record ID.
hth,
Jack
Dim StdResponse As Integer
StdResponse = MsgBox("You are deleting Record No " & Me.RecordID & " Are you sure", 0 + 4 + 256, "")
If StdResponse = vbYes Then
...delete code here...
Else '(Default)
... do nothing...
End If
Change RecordID for the name of your control that has the unique record ID.
hth,
Jack
