refresh subform

[asmith]

Hey everyone,

I have a form that has two subforms within it. What i'm trying to do is when a particular subform field is updated that the other subform is refreshed. What i've done so far is used the code builder (VBA) under the "After Update" event for the noted field and put the code



Forms![othersubformname].refresh

and that did not work. I also tried the requery command with no luck.

Can someone please help

Thanks
Andrew

[pbaldy]

You probably want Requery, and you'd need a proper reference to the subform:

Forms Refer to Form and Subform properties and controls

[HiTechCoach]

Try:

Me.Parent.[othersubformname].Form!requery

or

forms![PaertFormName].[othersubformname].form!requery


Note: Requery and refresh are not the same thing.

[asmith]

Thanks Paul,

Based on your reply i used the following code

Forms!Input Form!SICS subform.form!requery

but i still seem to get the following error:

"... can't find the object 'Forms!Input Form!SICS subform.'"

and i'm certain i've got the form names spelt correctly.

[HiTechCoach]

Thanks Paul,

Based on your reply i used the following code

Forms!Input Form!SICS subform.form!requery

but i still seem to get the following error:

"... can't find the object 'Forms!Input Form!SICS subform.'"

and i'm certain i've got the form names spelt correctly.

If you have spaces in the object names then you must wrap the names with square brackets.

Try:

Forms![Input Form]![SICS subform].form!requery

or

Me.Parent.[SICS subform].form!requery

[asmith]

Thanks for the reply guys,

I ended up doing a VB workaround that seems to work find for me. The code is:

DoCmd.Save
Me.Parent.Refresh

now i just have to put another line to have it go to the next cell automatically and we're good to go