Date Entry from Calander Control

[Guest]

If I add an activeX Calander to my form, How do you link it so the Date field
gets filled if they click the calander control for the given date?

Also if I was using the calander control to be part of a Control Panel and
select a date on the calander for the form to look up the data for that date?

any help?

 

[Arvin Meyer [MVP]]

If I add an activeX Calander to my form, How do you link it so the Date
field
gets filled if they click the calander control for the given date?

Have a look at:

http://www.datastrat.com/Download/XCalendar2K.zip

Also if I was using the calander control to be part of a Control Panel and
select a date on the calander for the form to look up the data for that
date?

You can use date textbox controls with a popup calendar on a dialog form to
lookup data in a query:

http://www.datastrat.com/Download/Calendar2K.zip

Select * From MyTable Where DateField = Forms!frmDialog!txtStartDate
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access