Date Picker Not Updating Bound Control

[DanKoz]

I have a simple form with several buttons to open data input forms or to run reports.



There are also two date fields on the form used to select the date range for reports. The two date input text boxes are bound to date fields in a table.

When I select one of the date input boxes on the form the date picker does appear and the date I selected with the picker does appear in the text box, but the value is not updated in the table that has the bound date field. Shouldn't this happen automatically? or do I need to write some code for the OnChange or other event?

If code is needed a sample would be appreciated.

Thank you.

Dan

[DanKoz]

I should point that if I make then changes in the date fields on the form using the date picker and then save the form then the dates do get updated in the related table. But do I have to save the form each time? shouldn't the table fields get updated as soon as the form field gets updated?

[RuralGuy]

Changed fields are only automatically saved as you leave a record or close the form.

[DanKoz]

Thank you!

My intent was to allow the user to run a report after they made the date selections. I was planning on keeping the form with the date fields open in the background while I present the reports. Is there a way to do that (i.e., keep the form open) or do I have to close the form and then open the report?

Thanks for your help.

Dan

[RuralGuy]

You can set the Form as invisible and run the report with the acDialog parameter and make the form visible after the report completes.

[DanKoz]

Thank you. I will brush up a bit to learn how to do this.

Dan