Problem with Setting Criteria in a Query from Form Textbox

[nikdiva]

Hi All,
Here is the problem.

I am using 4 textboxes to set the criteria in an Append query.

I have set defaults for 2 of them, the other 2 can't have defaults
set for them because I need to return all values for them if the user
hasn't specified a certain value.

So the query is returning no records because it doesn't like any of
the defaults that I set for these fields like: <>Space(0) or
Is Not Null, or Like &quot;*&quot;. Nothing is working!

Any ideas?

Nikki Wright
Database Specialist
&quot;But I'm not crazy, I'm just a little unwell&quot;

 

[BSman]

An append query? Are you sure you mean an append query? An append query will not return any records, it just adds records to a table.

 

[nikdiva]

Yes, I did mean Append Query. I meant to say when I browsed in Datasheet View it didn't return any records.

Anyway, I found the answer in thread 702-113995 in this forum.

Thanks anyway,
Nikki Wright
Database Specialist
&quot;But I'm not crazy, I'm just a little unwell&quot;