null date issue when using findfirst

[aft3rgl0w]

hey all, I'm using a listbox that displays the number, organization, name and
date from a distribution table. unfortunately, there is no key column (for
various reasons) so i've modified the underlying code for the AfterUpdate
action so it looks for the record matching all 4 fields in the listbox.
However, I run into a problem where there is no date filled in, I get a
syntax error. How can Imodify my code below to include the field, as it is
vital in some cases, but not get an error where there is no date? Thanks in
advance!!!

 

[Stuart McCall]

hey all, I'm using a listbox that displays the number, organization, name
and
date from a distribution table. unfortunately, there is no key column
(for
various reasons) so i've modified the underlying code for the AfterUpdate
action so it looks for the record matching all 4 fields in the listbox.
However, I run into a problem where there is no date filled in, I get a
syntax error. How can Imodify my code below to include the field, as it
is
vital in some cases, but not get an error where there is no date? Thanks
in
advance!!!

Although you forgot to include your code <smile>, you probably need to look
at the Nz function.