Did you blank the text box by setting its value to a zero-length string?
That's not a valid date. Set it to Null instead.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"HNIM2010 via AccessMonster.com" u59744@uwe wrote in message
news:a7f8f7b44f196@uwe...
Hi Allen,
Thanks for your response.
I say the notes at the bottom of the page earlier. But the VisitDate is
blank
prior to I click the button to update it. And it is a date field formatted
for short date. I dont have to enter anything more than what is there in
the
onclick event of the button. But there are some after update events for
the
field [VisitDate].
Perhaps there is something wrong the way I imported the module. After the
module is imported am I supposed to do anything like Debug etc?
Thanks
HNIM2010
Allen Browne wrote:
The bottom of the page at:
http://allenbrowne.com/ser-51.html
has a comment about the type mismatch error.
It indicates that your text box has a non-date value in it.
If you have other code you want to use in the same event, you can use:
Call CalendarFor(Me.[VisitDate], "Select the visit date")
in your existing event procedure.
I am trying to incorporate a pop up calender from Allen Browne.
Downloaded
the file (for Access 2000 and later) from the address below and unzipped
[quoted text clipped - 12 lines]
Thanking you in advance
Leo
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1