ACC2000: Data Unchanged When You Change Dates on Calendar Control

ID: Q225982

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).


SYMPTOMS

When you select a date on a Calendar control, the date is not updated in the field that is specified in the ControlSource property of the Calendar control.


CAUSE

The Calendar control does not update the field that is specified in the ControlSource property of the Calendar control until you either move the focus to another control or save the record.


RESOLUTION

Move the focus from the Calendar control to another control.

-or-

Save the record after updating the Calendar control by clicking Save Record on the Records Menu.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.


  2. Create a new form based on the Orders Table.


  3. On the Insert menu, click ActiveX Controls.


  4. Click the Calendar Control 9.0 and click OK.


  5. If the property sheet for the Calendar control is not visible, on the View menu, click Properties.


  6. Change the ControlSource property of the Calendar control to OrderDate.


  7. If the field list is not visible, on the View menu, click Field List. Drag the OrderDate field from the field list to the form. This should create a text box with OrderDate as the control source.


  8. On the View menu, click Form. Note that the Calendar control and the text box show the same date.


  9. Click on multiple dates in the Calendar control.


Note that your subsequent selections do not update the date value shown in the text box until you move the focus off the Calendar Control by clicking in the text box.

Additional query words: pra 


Keywords          : kbdta IntpCstm 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 19, 1999