null date issue when using findfirst

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
aft3rgl0w said:
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!!!
Click to expand...

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