Combo box help

[barra47]

I have a combo box which will show a list of cost codes e.g. 5-1420
but I find users are able to over type the data to something else e.g 51420
How can I stop a user from entering anything but whats in the lookup table that stores the cost codes.

Thanks in advance

 

[MajP]

see the "limit to list" property.

 

[TheAceMan1]

How are ya barra47 . . .
In the [blue]NotInList[/blue] event of the combo, try this:

[blue]   Dim Msg As String, Style As Integer, Title As String
   
   Msg = "You must choose and item in the dropdown list"
   Style = vbInformation + vbOKOnly
   Title = "Not In List Error! . . ."
   MsgBox Msg, Style, Title
   Me!Combo5.Dropdown
   Response = acDataErrContinue[/blue]

See Ya! . . . . . .