use calender to find dates

[datahunter]

i am using the calender to fill in a date field but have found a need to have
a search done to see if that date is used all ready. How do i add the
search part to my calender.

 

[Jeff Boyce]

Without a better idea of your underlying data structure (it all starts with
the data), it will be tough to offer specific suggestions.

I would guess that you would have to store, somewhere, the fact that a date
was "already used" (whatever that means to you). Could you try looking for
that date in that place in the BeforeUpdate event of the control in which
you are trying to store the date?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/