findrecord NULL

[Maarkr]

my form has info entered on it and later someone will approve it. I thought
I'd put a cmdbtn that, when clicked, would find the next record that is not
approved (is null) -i used AppvlDate field to check for the null value... I
tried docmd.findrecord null,... and variants but it says a value is
required... also tried goto record variations of this... rs.FindFirst
"IsNull([AppvlDate]) " and that didn't work... hope someone knows an easy way
to find the next null value in my AppvlDate field on the form

 

[KARL DEWEY]

I did not check this but try a macro - GoToRecord - Next - with condition -
IsNull([AppvlDate])

 

[Maarkr]

Thanks Karl, but that didn't work... I tried many variations of null but it
doesn't like it when searching for a record... if you put 'is null' in the
Edit..Find dialog, it works, but it just won't do it in VBA. . I went ahead
and just filtered the recordset, which gives me all the nulls, but that will
work for me... seems I always come up with crazy things that just won't work.

I did not check this but try a macro - GoToRecord - Next - with condition -
IsNull([AppvlDate])
--
KARL DEWEY
Build a little - Test a little

my form has info entered on it and later someone will approve it. I thought
I'd put a cmdbtn that, when clicked, would find the next record that is not
approved (is null) -i used AppvlDate field to check for the null value... I
tried docmd.findrecord null,... and variants but it says a value is
required... also tried goto record variations of this... rs.FindFirst
"IsNull([AppvlDate]) " and that didn't work... hope someone knows an easy way
to find the next null value in my AppvlDate field on the form