i am getting null value for result1.
form1![port1] and form1![port2] are returning the query result.

Set form1 = Forms![insert incoming data items]

    If IsNull(form1![port2]) = True Then

        result1 = form1![port2]
        result1 = result1 + 1
    Else
        result1 = form1![port1]
        result1 = result1 + 1

    End If
    form1![Text1] = result1

any ideas.
my final aim is to increment the query result by 1 and display in other textbox.

I don't understand what you are doing, or trying to do.

In psuedo code,

Take the value "insert incoming data items" from your form.

If "port2" is Null, then
   result1 = null
   increment result1 by 1 'increment a null?
Else if "port2" has some value, including empty string
   result1 = "port1"
   increment result1 by 1
End if

Display result1 in text1 on the form.

What are the values in the port fields? Are they integers? I don't think you can increment a null value by 1.

What should the query result look like?

mmcdonal

In response to your subject line, you can't really get a null value. You can check for null, but it doesn't have a value. Null has no value, and is not even equal to null.

mmcdonal

hi

I am returning result of count query in port1 as well port2.
now, i want to compare that result, if port2 have value then is increment by 1 otherwise port1 will increment by 1 and display that result in text1.
port1 & port2 are list box
text1 is text box.

Form1.Text1 = Nz(Form1.[port2], Form1.[port1]) + 1

And if Port1 is possibly null, you can set a default of, say, zero. In that case Text1 will be equal to one.

Form1.Text1 = Nz(Form1.[port2], Nz(Form1.[port1], 0)) + 1


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division