Making a field housed within a combo box mandatory

[Milo320]

I have created a combo box in a form. I want to make it so that neither value that I entered into a Row Source populates automatically, but rather the user has to go to the box and select either a yes or no from the drop down. How do I make that combo box mandatory?

 

[John Big Booty]

In the form's Before Update event put the following code;

If IsNull(Me.YourCombo) Then
     MsgBox "Please make a selection from the list"
     Me.YourCombo.SetFocus
     Me.YourCombo.DropDown
     Cancel = True
     Exit Sub
End If

 

[John Big Booty]

... and welcome to the forum

 

[benzhu]

the property -> Data -> there are two properties: Limit to List (Yes), and AllowValue List Edit( No )