setting a null date

  • Thread starter Thread starter liz
  • Start date Start date
L

liz

In the following code:

EndDate = rsCompleteEpisodes![End]
rsCompleteEpisodes.MovePrevious
rsCompleteEpisodes![End] = EndDate

If the the date in rsCompleteEpisodes![End} is null I get
an error

Run-time error '94'
Invalid use of Null

I do need to pass this null date back to the previous
record - any ideas?
 
How have you declared EndDate? If you declared it as a Date, that's your
problem. The only variable type that can accept a Null value is a Variant.
 
Thanks
-----Original Message-----
How have you declared EndDate? If you declared it as a Date, that's your
problem. The only variable type that can accept a Null value is a Variant.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



In the following code:

EndDate = rsCompleteEpisodes![End]
rsCompleteEpisodes.MovePrevious
rsCompleteEpisodes![End] = EndDate

If the the date in rsCompleteEpisodes![End} is null I get
an error

Run-time error '94'
Invalid use of Null

I do need to pass this null date back to the previous
record - any ideas?
Click to expand...


.
Click to expand...
 
Back
Top