combo box

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I've a form which uses as its data source a query. I've added a combo box to
the form using the wizrd. On the Combo Box Wizard screen that first comes
up, I chose option 3 - "Find a record on my form based on the value I
selected in my combo box". It works fine except if I type a value in the
combo box that isn't in the list, it simply chooses the nearest record. I do
have the Limit To List property set to Yes. What else do I need to do to
have it return only an exact match?

Ivor
 
I've set the Not In List property to open a different form so I can add a
new record.
 
Back
Top