To whom it may concern about

Dear Sir, Madam

How are you doing? My name is Joe, and this is my first time that I use this
service to ask for the question. My question is:

I created a search box and search box is link to SQLDatabase. When I enter
the SSN in the search box and click "Search" button to locate if there is an
existing SSN on SQLDatabase or not. If not, then I wish to create a message
that display on pagetitle which says "Please enter a new record". If yes,
there is an existing SSN on the SQLDatabase then it will display a message
"Please update your existing record".

I try so many ways to see if I can display that message but I could not.
Would you(someone) please show me how to create this message.

Thank you
V/R
Joe

my email:

G'day Joe

Don't think this is the right newsgroup you need.

But for what is worth, I can give you the VBA equivalent of what your after.

Sub YourControls_AfterUpdate()

Dim TheMessage As Integer

TheMessage = MsgBox("What you want the Message to Say", vbOKCancel)

If TheMessage = vbOK Then
DoSomething
Else
CancelEvent = True
End If
End Sub

HTH
Mark