Search form not work suddenly.

  • Thread starter Thread starter Andrew Tatum
  • Start date Start date
A

Andrew Tatum

So, I was 95% done with this form. I then went back and tried it
again... this time the wiered thing happened.

I have a qRateLess and qRateLast field. It's like "Choose the minimum
or maximum"

The Min/Max fields on the form have the EXACT same properties. However,
when I put something in the Minimum field... it goes blank claiming
there are no records. However, if I pust put something in the maximum
field... it comes up with a ton of stuff.

Here is the query that the form hits:

Between (NZ([Forms]![Message Report Query Center]![qRateLess],0)) And
(NZ([Forms]![Message Report Query Center]![qRateLast],10000000000))

I believe it's correct. I have qRateLess to be set to 0 if blank and
qRateLast to be set to a really high number is blank.

Any ideas what could be causing the chaos here? It's driving me insane!
 
Back
Top