Control source problem

[lfolger]

Hi,
I'm new to this forum and I have a question. I have a form which has a subform. The main form has a date which when entered or updated I want to flow down to all the records on the subform. I get that to work perfectly. My problem is - the users still want to have the ability to change the date on the subform if they need to. IS this possible? I have the Control Source on the subform date field reading =[Forms]![frmTMF data entry]![Date] so it doens't allow user input. Is it possible to have the field updated automatically and allow the user to change it at will? any ideas would be greatly appreciated. thanks.

Lisa

 

[RuralGuy]

Since your SubForm control in not bound to a field, it does not remember the date. What is the purpose of having such a control in the subform?

 

[lfolger]

I figured out how to do this - I created an update query which updates the date in the subform to the date on the main form - i run the query on the after update control on the date field in the main form. this way my dates in the subform get updated but can also be changed if needed.