Hi Chuck,

I'd write it along these lines:

 Const MSG_TITLE = "Confirm Change of Address"
 Dim strMsg As String
 
 strMsg = "You are changing Client " & vbCrLf _
   & Me.First_Name.Value & " " & Me.Last_Name.Value & vbCrLf _
   & "to Address blah blah"

 If MsgBox(strMsg, vbExclamation + vbYesNo, MSG_TITLE) = vbYes Then
   'user said yes

 Else
   'user said no

 End If

Note that you have to add the vbExclamation and vbYesNo constants to
get a single value to pass to MsgBox().

For the text boxes: if you want to find out if a textbox is empty
(either Null or an empty string), use

 If Len(Nz(Me.txtXXX.Value), "") = 0 Then

If you want to catch Nulls but allow empty strings (which seems
unlikely), use

 If IsNull(Me.txtXXX.Value)
   

--
John Nurick - Access MVP

Hi Chuck

if the text box is called something like txtInput then you can use something
like this

dim strMsg as String

if is null(strInput) then
  strMsg = "Please put something in the text box."
  msgbox strMsg, vbCritical, "No Input"
end if

For the Go_Click try this:

Private Sub Go_Click()
Dim Answer As Integer

Answer = MsgBox ("You are changing Client" & vbCrLf &  _
Me![First_Name] & " " & Me![Last_Name] & vbCrLf & _
" to Address blah balh ", vbExclamation, vbYesNo)
If Answer = vbYes Then
   MsgBox "you said Yes"
 Else
   Beep
End If

End Sub