Search Form

[accessturtle]

Hello to all Access Expert,

I am very new to MS Access but have a background in Excel, i understand that there is a good diffrence between Access and Excel. Now coming to the point: i have created a database to record all the incoming complaints for a comapny which is working fine but now i am facing a challange to create a Search form that will allow user to for possible matches, for example

[Text box] [combo box] [command button]

Text Box: I want user to type in whatever they want to search e.g Customer, Phone number, Complaint number etc i also want user to perform partial text search if they dont remember the entry.

Combo Box: In this i want user to make a selection in which field they want to search e.g Phone Number, Complaint number, Customer Name, Source etc etc by the way these are my field names in table

Command Button: This is pretty much self explaintory, a button to perform the search. Altough i also want user to press enter to perform search.

I have been searching this on the internet for past 2 days but cannot find anything,

Thank you in Advance
Access Turtle

 

[pbaldy]

There are any number of ways to do this. The sample db here demonstrates one:

http://www.baldyweb.com/BuildSQL.htm

 

[John Big Booty]

Here's a link to another search tool that dynamically searches multiple fields as the user types, see post 6-8

 

[accessturtle]

Dude you are awesome!!!!!!!!!!!!! thank you sooo much for your help.... just one more question... how can i sync the data displayed on search result on to the form? maybe dbl click it or something

 

[accessturtle]

Sorry Please disregard my question as i went to one of your previous posts and found the answer and it worked great.... Thanks Again!!!!!!!!!!!!

http://www.access-programmers.co.uk/forums/showthread.php?t=188209