Thread: Query for search fields on form

Hi All,

Ok, everything seem to be working ok until I added this criteria for one of the fields in the query and on the form.

Code:

>=[forms]![form4].[qDays]

All the other fields use something like :

Code:

Like [forms]![form4].[qEquipment] & "*"

Is there an issue with using a like in some criteria and >= for another?

I have qEquipment, qAsset, qIDNo using like and all seems to be working on the search screen, meaning if I only enter data in one of the fields I get results or if I filter further and enter data in two or all three fields I still get results but as soon as I added the qDays then if I try to enter Equipment it doesn't work but if I only enter data for Days it works...

I checked the data types and all are text except "Days" ..."Days" is number, is this the problem?

Should I be having something for Nulls?

I put on the textbox properties default value = ""