have you tried using a star filter for example you enter 112* it should return all records that begin with 112*(any character after the 2.
That would at least narrow the search down. Thanks Eileen --- In [email protected], Bill Knight <[EMAIL PROTECTED]> wrote: > > I have a table with a test field that is defined with a 'look up' property. I have a form with a list box linked to that field. > > I desire to be able to select the list box on a form and enter value and have that value displayed in the form. I have it somewhat working, but not completly. When I select the list box and enter a value I am presented with the first entry in the table matching the number I entered, I want to continue and enter the second diget of the number. That is where it gets strange. For example if i have the value '112233' and '222333' in my table my results are always based on the most recient number I entered. In this case if I entered '1' I would get the first recored '112233', if I enter '1' again I still get the same record, If I enter '112' I get the second record '222333'. How do I tell access to look at my entire entry, not just the most current key stroke? > > > Bill > > [Non-text portions of this message have been removed] >
