Printable View
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.
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]