Search Form

accessturtle

XL Guru but new in XS
Local time
Today, 17:03
Joined
Feb 26, 2010
Messages
12
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
 
Is something you are looking for:

http://www.designedlogic.com/Originals.html

I use two method

1) You can search for one only of the criteria Customer, Phone number, Complaint number

OR

2) Search no manner what criteria used.

Any preference.

Simon
 
Check out this thread:

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

I was looking for a similar solution as you, however I came across that thread and the solution Big Booty John developed - it is outstanding. You won't need a combo box or a command button, just start typing in the text field and it will populate the subform with matches. Then dbl click on the match and it'll pull up the record.
 

Users who are viewing this thread

Back
Top Bottom