NotInList event (1 Viewer)

[mlopes1]

I put some code into NotInList event of a combo box. Code works well, shows up when it should etc.
Only problem is that after my message box appears and is cleared, default system message still appears too. How get rid of the default. Code I wrote below:

Private Sub Check_Stock_NotInList(NewData As String, Response As Integer)
Dim msg As String
msg = "My Text Here."
MsgBox (msg)

End Sub

 

[ListO]

Try this…

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

Dim msg As String

msg = "My Text Here."
MsgBox (msg)
Response = acDataErrContinue
End Sub

The Response tells Access what to do. See "NotInList Event - Event Procedures" in the Access Help.

Good Luck

 

[mlopes1]

Thank you. It so simple, but must skipped right over it in help screens.


Marco