Update a form field by clicking a calendar on the same form

[Asolandri]

Hi all,

Sorry for the newbie question, here is the scenario:

I have a form that runs a query when a button is pushed. The query uses the values keyed into a begin date and an end date from the form as selection criteria. I would like to insert a calendar on to the form and allow the user to click it updating the begin and end dates, toggling between the 2 and starting with the begin date. Help please =)

 

[mp9]

An easy and totally native-to-Access solution is the calendar control replacement available free from

http://www22.brinkster.com/accessory/forms/005.shtml

 

[JerryKlmns]

In my Access 2000 toolbox there is an ActiveX control
[MSCAL.Calendar.7], the Calendar Control 9.0

You could use the ActiveXCtl0_AfterUpdate() event to write your code like

txtToday.Text = Day(ActiveXCtl0.Value)