Trapping Null Values

  • Thread starter Thread starter CHARLES.CLAYTON
  • Start date Start date
C

CHARLES.CLAYTON

A2K

I have a subform based on a query (which takes data from two tables)
that runs some calculations on that data which then puts the final
product into a new table. I do this by opening a recordset using the
..addnew and .update features. This all goes fine. My problem is that
sometimes I am missing data from fields. Ideally, I would trap for
this error at the main form which takes the data for the two tables.
Unfortunately, not all the fields are required all the time and I am
not able to make it a requirement.

As I said I have no problems opening the recordset and running the
calcuations and then populating the data in a new table. What I am
unable to do is to trap for any null value. I would like to have the
subform issue and error message to the user when the data is missing so
that they will go to the proper form and input it and then come back to
the subform and run the calculations.

Thanks,

Charles D Clayton Jr
 
Hi
isnull function is for trapping null values .

if you want to check textbox named txtdata null value :

if isnull(me.txtdata) then
msgbox "the data is null"
end if
 
Back
Top