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?