requery subform

[Sade]

Hello. I have a date field on a subform that is defaulted to the date field on the main form. When I change the main form's date, I want the subform's date to change as well.

To do this I am using the "requery" command in the "on change" event property of the main form's date field. When I open the forms, the defaults all work, but when I change the date on the main form, the subform requeries to show the data that is in it's table, not the new date value on the main form. Is there a better option than requery?

 

[Montez659]

When you say that that the subform is defaulted to the main form date field, how is it defaulted? Is it a simple expression like

 =[myMainForm].[dateField]

What you should be able to do is reference the control on the subform (I am assuming that you are showing it in form view and not datasheet or something else) like this:

 Me![mySubform].Form!mySubformControl.Value = myMainFormControl.Value

This would go in the After Update or Lost Focus event, or however you want to do it.

For some good reading and reference, this is my go-to guide on how to talk between forms:
http://access.mvps.org/access/forms/frm0031.htm

Let me know if this helps.

 

[Sade]

You nailed it! Thats exactly what I was doing, and your code did the trick. Thanx a ton!