Combo Box - Strict Data Entry

[canjfn]

When using a combo box to enter someones name, I want the data entered to be from the combo box only eg.

The Combo Box has a list of say three name
Joe Bloggs
Joe Bishop
Mike Davies

I do not want the field to allow the inputting of any other name than what are listed in the combo box

What I want to stop is users who keep changing the way the enter their name
eg J Bloggs, JB, Mr Bloggs etc

So basically a piece of code which says " Is the name listed in the combo box, yes, then proceed, No msg "Please select Name from Combo Box only"

Hope this is clear

Thank you in advance

 

[ansentry]

Have a look at the attached sample, is this what you want?

 

[canjfn]

Thats exactely what I was looking for

Many thanks for your help

 

[Mile-O]

Not looked at the example so it may be what I'm going to say:

I just set the combo's LimitToList property to Yes

Then I open up its NotInList event in the Code Builder and type:

Response = acDataErrContinue

That's it.