Hi, I have a form with Calendar ActiveX Control and a Command Button. I 

wish to allow my users to click a date from the Calendar Control and once 

the user click the Command Button, it should send the value from the 

Calendar and run the query based on the Date value selected in the 

Calendar Control.



How can I do that?



Thanks,

Maha

In your query you have to refer to the control through the forms collection

eg     forms![formname]![controlname]

----- Original Message -----

From: "Maha Arupputhan Pappan" <mahap@p...>

To: "Access" <access@p...>

Sent: Thursday, December 20, 2001 7:57 AM

Subject: [access] Passing values into Query from Form





> Hi, I have a form with Calendar ActiveX Control and a Command Button. I

> wish to allow my users to click a date from the Calendar Control and once

> the user click the Command Button, it should send the value from the

> Calendar and run the query based on the Date value selected in the

> Calendar Control.

>

> How can I do that?

>

> Thanks,

> Maha

Maha,



Go to Microsoft's Knowledgebase and download the file at

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q165437

(Article Q65437).  The file, Actxsamp.exe is a self-extracting file and

shows you samples of how to use some ActiveX controls, including the

Calendar Control.  It is for Access97, but works just as well in

Access2K and AccessXP.





John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: Maha Arupputhan Pappan [mailto:mahap@p...]

Sent: Thursday, December 20, 2001 7:58 AM

To: Access

Subject: [access] Passing values into Query from Form





Hi, I have a form with Calendar ActiveX Control and a Command Button. I

wish to allow my users to click a date from the Calendar Control and

once

the user click the Command Button, it should send the value from the

Calendar and run the query based on the Date value selected in the

Calendar Control.



How can I do that?



Thanks,

Maha