How to handle multiple null values using form-based parameter queries?

[tim_tims33]

Hi, i'm creating a search form giving the end user a range of controls to use when filtering/searching data. See the image.

But, i think my range search (using the textbox) to put in a lower and upper limit...is preventing this from working. In fact, when i put data into all the controls, no data pops up in my subform. How can i get around this?

My query data source can also be seen...showing you how i've handled teh null entries. (Hmmm..perhaps i need to put in a null 'handler' for the two textboxes??)

Please advise where you can...

Many thanks
tim

 

[John Big Booty]

The sample here whilst not directly addressing your question may be of interest to you.

 

[Brianwarnock]

Drop the Like, the principle is
Field=parameter or parameter Is Null

Brian