Adding search facilitiy on forms linked to tables

[Only1Abhi]

Hi.
I tried to get my head around this but it simply wouldn't work.

My Table: "tblCustomer"
My Form: "frmCustomer"

In Form View, I want to include a search engine facility. It needs to be designed in such a way that I type a surname of a person (in a text box) that is already in the table and all the people with that surname should appear on the form for me to flick through. Does any1 know how to do this?

Thanks a lot in advance.

But those people who think this is a piece of cake, this isn't the whole problem. Infact, I was thinking of some way where I could get the search results to appear in a box like in a website. (I.E. When I type a typical surname such as Smith in the text box, I want all the Smiths to appear in a box like a list along with their first names so that I can just click on one of them and view their details).

Does any1 have a solution to the first and/or second part of my problem? If so, plz post it here because I've been asking all programmers I know like mad and know1 seems to know the answer to this.

Thanks a lot in advance... any1 who solve the 2nd problem is a true genius!!!

Waiting urgently for replies.
Regards,
Abhi

 

[mikey69]

This is simply achieved using a combo box control. You should design a query to associate with the combo box which has a composite field using last nmae and first name. sort this field and you'll be away.

 

[Only1Abhi]

Mikey, I don't want a combo box.

Do u know any other solution? Thanks Anyway!

Any1else with solutions also plz help.

Regards,
Abhi

 

[mikey69]

But what you describe is precisely what a combo box is meant to do.

If you really don't want to use a combo box, you could achieve what you want through VB code, but at considerable effort and I doubt whether anyone on thes forums would help you to do it, just because a combo box does it all anyway.

 

[InfoNow]

Abhi,
Have you tried these FAQ in the Forms forum?

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=2039

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=1177

 

[Only1Abhi]

thanks a lot InfoNow

u've really helped me!

many thanks to mikey aswell!

My problem is solved now.

Regards,
Abhi