Update subform field

[machine08]

Hi all,

I have a frm_Main which contain another form: frm_SubForm.

When I in the subform I would like to get a value from the frm_Main and copy it into a frm_SubForm field. I'm having a hardtime doing this. Here's what I have so far:

Forms!frm_Main!frm_SubForm.Form.ItemToUpdate.value = Me.ID.Value

Would appreciate if someone could help me figure out what I'm doing wrong.

Thank you!

 

[PHV]

Like this ?
Forms!frm_Main!frm_SubForm.Form.ItemToUpdate.Value = Forms!frm_Main!ID.Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeeThru]

Hi Machine08

What error do you get?

 

[TheAceMan1]

[blue]When [purple]I in the subform[/purple] I would like to get a value from the frm_Main . . .[/blue]

[blue]   Me!ItemToUpdate = Forms!frm_Main!ItemToGet[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[SeeThru]

aha...

or me.parent!itemtoget

 

[TheAceMan1]

Howdy SeeThru . . .

Correct me if I'm wrong, but the [blue]parent of a control on a subform[/blue], is the subform! Giving:

[blue]   Me.Parent.Parent!ItemToGet[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[SeeThru]

Hmmm..cant remember - I'd just try it to see what worked!