Search button

[rhonda11]

Just an general question, I also wanted to create a search form. Whereas you have a text field and a search button that can search for keywords or partial word base on what you entered in the text field. Then, the result would either found an exact match and bring up that record or could be more. Can access do that? How, can somebody show me.

Thanks in advance.

 

[jbehrne]

Hi,

It sure can. You have several options also. The easiest way would be to create a select query that references the table that you are searching in. In the field that you wish to search just type in the Criterial Field this:

[Enter Text To Search For]

Set this query to the Record Source of the form. Wallah - when the form is opened a message box will pop up and if the record is found it will then open the form with your record displayed. Then all you have to do is create a button and have it open the form. - However, it does have some draw backs: this will only search one field and I think that it will only handle complete keywords...

You can also try the DLookup function and set it's returned value as a bookmark and requery your form based on the bookmark value. But, there are plenty of ways to skin a cat....

jbehrne

 

[rhonda11]

Thanks for your respond but I understand the parameter. However, what if you what to customized your own search form. Let say, I pull the form with the customer record but I would like to create another text field and a search button within the same form incase I what to retrieve another customer and that customer would display on the current form. And of course I would like to be able to search partial word instead of exact name of the field (kind of like a search browser)

Thanks again

 

[jbehrne]

You can use the DLookup function (see Access VB Help for more info), or the Find Method (ADO) . The DLookup will search a particular field for the value and you can use the bookmark function (see Access VB Help for more info) to requery your form based on its result. That being said, and I don't know if you want to avoid it or not, but the canned Access search wizard seems to do the job for me. It also allows for partial searches and it will allow you to search in anyfield.

jbehrne

 

[jbehrne]

Hi rhonda11,

I did finally find something that may be what you are looking for. Check out this link:

http://www.mvps.org/access/forms/frm0045.htm

Hope this helps,

jbehrne