Not in list

[Guest]

Anyone can advise how can I get rid of the "not in list" error message Access
gives when we try to put in text that is not part of a combo box?

Thanks.

 

[ALESSANDRO Baraldi]

Anyone can advise how can I get rid of the "not in list" error message Access
gives when we try to put in text that is not part of a combo box?

Thanks.

May be this one solution...?

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Select Case DataErr








' --------------------------------------------------------------------------
---------------
' This to prevent "<NOT IN LIST> on Combo(s) if it's not allowed








' --------------------------------------------------------------------------
---------------
Case 2237 ' NOT IN LIST
Response = acDataErrContinue
Screen.ActiveControl.Undo
Case Else
Response = acDataErrDisplay
End Select
End Sub

 

[fredg]

Anyone can advise how can I get rid of the "not in list" error message Access
gives when we try to put in text that is not part of a combo box?

Thanks.

What do you want to do with the text that you tried to place in the
box (besides get rid of the message)?
Save it? Delete it?

 

[Guest]

I'd like to save it so that I can put it in a text box on a form that will
open.