Disabling typing in a combo-box

[Cameron Sutherland]

You can tell Access to ignore the error and even reset the
value entered through code:

Private Sub cboWhatever_NotInList(NewData As String,
Response As Integer)
Response = acDataErrContinue 'Ignore error
cboWhatever.Undo 'undo users typing
End Sub

If you add the undo line it removed their typing. If you
omit it it automatically drops down the combo box but
keeps their typing intact.

Will this accomplish what you are trying to do?

-Cameron Sutherland

 

[Yair Sageev]

I guess this would work, but it might confuse users if they type and their
typing is reset. I'd prefer the combo didn't let them type at all, only
select.