Hi,

I have data of type "number" shown in the drop-down combo-box in a form. It has some codes in the event of "After Update".

My problem is that i can't type in something like 13* in the combo-box in order to get anything starts from 13. It says "The value you entered isn't valid".

The reason is that i want user to be able to use the wildcard. I know that i can do this with text. I'm not allowed to change the structure of the table in the database.

This combo-box shows IDs from one of the exisiting tables. That IDs is of type "autonumber" in the table.

Is there a better way of doing this?

Thank you in advance

Hi

Try basing your form on query which is a duplicate of the source table then add an extra field in your query which would lokk something like this:

TxtNumber:CStr([NumberField])
Then when you want to perform a wildcard search use the TxtNumber field instead of the actual numeric field.

Code Master:cool: