Message box

[Dorothea]

I have a list box that is being used as a record search.
I want to put the message "The record you are looking for
does not exist, please verify and try again." I was
trying to put in the Not in List

Private Sub Combo278_NotInList(NewData As String, Response
As Integer)
End Sub

How do I create the message?

Thanks

 

[Guest]

MSGBOX()

 

[fredg]

I have a list box that is being used as a record search.
I want to put the message "The record you are looking for
does not exist, please verify and try again." I was
trying to put in the Not in List

Private Sub Combo278_NotInList(NewData As String, Response
As Integer)
End Sub

How do I create the message?

Thanks

1) A List box is not the same as a Combo Box.

2) In a combo box NotInList event, if all you wish to do is show the
message, and nothing else, then:

Private Sub Combo278_NotInList(NewData As String, Response
As Integer)

MsgBox "The record you are looking for does not exist, please verify
and try again."
Response = acDataErrContinue

End Sub