NULL Prob. Please Help

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

Hi!
I designed a subform on main form for searching records.
Every thing is working fine except Null values. In the
main form I created a combo control where I want to filter
records based on criteria given in the combo field
(*,'Yes','No',Null). Things working fine with
*, 'Yes', 'No' but is not working With Null. In the query
of sub form I gave Like <forms control>. Kindly help how
to solve the prob.
Thanks for any help.
Krish
 
Well, using a bit of logic... since it works for *, Yes, No, then I would
think...
NOT * or Yes or No
should yield the nulls.
Without seeing your combo query, and the code you use to filter the sub, I
can only suggest this... more as a workaround
than a solution.
Al Camp
 
Back
Top