Hi Friends, I am using MS Access 2007. I have table called "City". The table "City" contains the information of the different cities of INDIA with their details.
For example, City Details Mumbai It is the Financial capital of India Delhi Capital of India I have also form for retrieving details of the city It contains the drop down list for all cities of India If I select Mumbai from the drop down list, then it should display the details. However, I have another search option i.e. "Search by Keyword" In Search by keyword, if we enter any string from the details column. It should display all records that consists the specified string. For example, if we enter the string "capital" in text box, then it should display all records containing the string "capital". I need the macro (or any other solution) to do this. I hope, I am able to explain what I need. I know, this group is dedicated to MS Excel only. But I also know there are many experts who does well in Access as well. So I request all please help me by providing suitable solutions. Appreciate your help !!! Thanks in Advance !!! -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.