searching through records

[hux777]

Can anyone please help me. I have a customer databse, when i type in the name of the customer field, how can i get it to automatically search for all those customers similar to my required search.

EG. i am looking for a customer called DATACONNECTION.

if i start to type in d a t , how can i get the form to automatically take me to my intended target.

Thank you in advance for any help it will be appreciated.

Hux

 

[bri822]

I had to do something like this before. The way that I did it was with a LIKE statement. It should be explained alittle in your help menu. It is used in an SQL statement and allows for "wildcards" or unknown symbols. For example, Dat* would bring up any records that started with "Dat". I believe that is what you are trying to do. Start there and if you still have problems let me know and I can see what I can do to give you examples.

Brian

 

[iangirven]

I assume you have this form based on a query for a particular table.

eg customer form is based upon "getcustomer" query that users the "customers" table as its record source.

if this is the case you can enter the following into the criteria for the field that you want to base the search on ie. customername.

like"*"&[Enter Customer Name]&"*"

this will return all those records with simmilar entries in the fields.

this method opens up an input box to enter the data. You may decide it better to enter the data in a text box on your form and link to that text box (between "*"& &"*"). you can use the expression builder for that bit.

I hope ive understood your question right and hope this helps.

ian