I have Access 2002. I have encountered an anomoly with a form that has it's DefaultView set to Continuous Forms. In the form header are several unbound fields that are used to gather data to form records that will be inserted into the table (using event code with a command button that is also in the form header) that the form's RecordSource is querried from. I have the AllowAdditions property set to No because (obviously) I don't want to permit direct data entry to the table. With the AllowAdditions property set to NO I am experiencing a problem when attempting to update control values in the form header. If i simply create a text box and set it's ControlSource to some other form field it will not update when the source control is updated.
For example: I have a date field that can have a date entered directly or the user can click a command button that loads a popup that has a calender control to select a date this way. The command button code should set the date text box to the value chosen in the popup but it simply will not when the AllowAdditions property is false. It set to TRUE then it will work. The textbox property is being updated but not updated on the screen. I know this because if i select a date in the popup and then put the form into design mode and bring it back to view mode the previously chosen date will magically appear.
Anyone out there experienced this?
For example: I have a date field that can have a date entered directly or the user can click a command button that loads a popup that has a calender control to select a date this way. The command button code should set the date text box to the value chosen in the popup but it simply will not when the AllowAdditions property is false. It set to TRUE then it will work. The textbox property is being updated but not updated on the screen. I know this because if i select a date in the popup and then put the form into design mode and bring it back to view mode the previously chosen date will magically appear.
Anyone out there experienced this?
