Is there a way to sequentially search a form field?

[elvanace1]

Is there a way to sequentially search a form field? Meaning, is there a way to place the cursor in a specific locked field and begin typing the desired value (without Ctrl-F) and have Access start searching automatically?

Thanks, Eleanor

 

[lupins46]

When you type into a field you are entering data into a record. Access isn't going to search for anything.

Explain what you are trying to acheive and someone will assist.

 

[elvanace1]

No, the field in the form is locked so the actual data cannot be modified. I have a user that would like to just start typeing there search criteria. Then with every key-stroke have access narrow the search results.

 

[PHV]

And what about a combobox with AutoExpand set to true ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[elvanace1]

I changed the field to a combo box and set AutoExpand to True - but that didn't work. Did I do it wrong?

 

[lupins46]

You cannot (easily) use the same field as a data entry field and a search field.

If you want to find a record in your form you should add a second combo box to the form, using the control wizard and make sure you select the option to 'find a record in my form'.

Ypu other main alternative is to use the filter by form feature if thatis available on your toolbar.

 

[elvanace1]

Adding a second combo box to the form, using the control wizard and make sure you select the option to 'find a record in my form'works. Thanks so much!