Subform field needs main form refresh to load.

[Huddle]

I have a calculated sub - subform field named "Replacement" that should popluate when data is entered into the field "DateInstalled". The only way it populates is when I refresh the main form. I tried to do an After Update on the DateInstalled field to refresh the main form but do not know the right code to use. Please let me know what code would do this. The main form is named "Fm_Inventory".

[JeffChr]

It sounds like you might be trying to refresh the main form from code in the subform. If so, try:

Me.Parent.Requery or Me.Parent.Refresh

[Huddle]

This seems to work but it puts the focus on the main form after the refresh. How do I keep the focus on the subform.

[JeffChr]

put this line after to requery/refresh and substitute the name of a control on the subform for "controlname"

me.controlname.setfocus

[ItsMe]

The Requery method will cause the entire recordset to be re-queried and move your current record to the beginning of the recordset. If this is not acceptable, you may need to employ DAO and the Bookmark method.

[Huddle]

That didn't work. How do you do the DAO and Bookmark method?

[ItsMe]

That didn't work...

What did not work?

[Huddle]

me.controlname.setfocus

[JeffChr]

substitute your control name for "controlname". what did your code look like?

[Huddle]

Me.Parent.Requery
Me.LastTested.SetFocus