Hi,
as i understand - solution it can be like this:
you can use DateDiff() function to determine if selected date within next 7
days, and then display a form in dialog mode, with textbox for entering
password, ok and cancel buttons.
HTH

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
> Hi,
> I have a calendar control on my form that is bound to a
[quoted text clipped - 4 lines]
> access or create a new record). Any ideas?
> Thanks in advance
K Crofts - 28 Jul 2004 12:22 GMT
Alex to the rescue again, cheers mate
>-----Original Message-----
>Hi,
[quoted text clipped - 14 lines]
>
>.