Problem getting combo box to require user input

[newcoder54]

I have a combo box on a form. When the form opens, Set Focus is on the box. I want to require the user to select a name from the drop down or not be able to go to other boxes if they do not. Ideaa please. Not seeing what I need from older tips so far.
Thanks

 

[PHV]

In the Exit event procedure of the combo, either this:
If Me![name of combo].ListIndex = -1 Then
Cancel = True
End If
Or this:
If IsNull(Me![name of combo]) Then
Cancel = True
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886