combo box

[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

 

[Guest]

What do you want Access to do if it is not an exact match?

 

[Ivor Williams]

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

 

[Guest]

Try setting the "Auto Expand" property to NO.

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