Access not VB, but I might need some VB script

[Sacha Rowland]

Dear Programmer,

I once saw someone create a form that could use the activex calendar control in Access to create criteria for a report on products sold within a specific period of time without needing to type the dates in.

Can anyone give me an idea as to what I need to do to achieve this?

Cheers,

Sacha.

[gravyboy]

Sacha,

I will email a bit of help when I am at home (I'm at the girlfriends at the moment! She hasn't got Access!).Simply drop the control into a form and name it what you like. From there you can set up a couple of variables d1 & d2 that can be set using the line Calen.value=d1.


Matt

------------------
Matt G
Either [email protected]] or [email protected]