Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft Access Queries

Status
Not open for further replies.

poppadoc75

Computer
Jul 22, 2005
10
I am having trouble with a form that I'm doing. I just started using Microsoft Access, so I don't know that much. So in my database I have a table with the fields: Library, Program Names, and Description. In the form you input a word or phase and it searches all the rows in Description, then gives you multiple searches of program names, the library they belongs to and the entire description of the program name. I have this set up using a query where the criteria is Like "*" & [Forms]![Program_Name]![SEARCH_DES] & "*" and the requery macro to search for the program names which works just fine. But my problem is when i type in a word that has no matches, all the fields dissappear on the form and i have to close the form to restart it. How do I fix this problem?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor