Blank field

[checoturco]

Hi list,

I have two combo boxes and if one is blank, i.e. if the combo don´t show any text, and the other shows any text,it runs one query,if not it runs another query.
My question is:
How do i know if the combo don´t show any text?
i already test this code:
if ((isnull(combo_name1.value)=true) and ((isnull(combo_name2.value)=true) or
if ((isnull(combo_name1.column(0))=true and ((isnull(combo_name2.column(0))=true))or
combo_name1.value="" and combo_name2.value=""
and this doesn´t work.
I read the access help about isnull and there explain that isnull is to test if a variable is null or not and i don´t know if we can use this function on the controls(combx,txbox,etc).

the first combo have a query that brings text and the other combo brings integer

tks in advance for all,

Checoturco

 

[seth_belgium]

If IsNull(Me.ComboName.Value) then
   'It is empty...
Else
   'It's not empty...
End If

Seth

 

[checoturco]

tks, sometimes we must stop and requery our brains to get the right way :|