View Full Version : Criteria Based On Unbound Form Not Working


Randomblink
12-04-2001, 07:41 AM
Ok...
I have three text fields...unbound...
I labelled them correctly...

txt_ProjectNumber
txt_ProjectEngineer
txt_Firm

Now, JUST in the testing phase, I open the form...
I goto criteria in the Query in questions...
And I build the criteria...
I point the criteria to the individual text boxes, and if there is data in them...THEY WORK!
If they are blank...NOTHING COMES UP!
Argh!
I have done this in Access95, but now it doesnt work? Can someone point out my problem PLEASE!

Thanks alot...

jwindon
12-04-2001, 04:59 PM
Randomblink:

What you want to do involves identifying the fact that the text boxes are null.

This was where I learned to do these queries. Have fun!
http://www.access-programmers.co.uk/ubb/Forum4/HTML/004007.html