Displaying a Field Value From Another Form

[Lupson2011]

Hi

I am trying to display a field value from a different form but keep getting a name error?

Essentially, I have the original value in SubformSOFA_DATA_ENTRY form, in a field entitled U_Vol_Inc, but I want to display that value in another field in another form.

I created the text box in the new form and put the following argument in..

=[Forms]![SubformSOFA_DATA_ENTRY]![U_Vol_Inc]

As the original form where the value is held is a subform, do I need to increase the path to incorporate the parent form as well?

If anyone can let me know why I get the name error that would be great

thanks


Lupson2011

[Robeen]

Try this:

 
=Forms!SubformSOFA_DATA_ENTRY.Controls!U_Vol_Inc

Let us know if it works!

[Lupson2011]

Hi

thanks for your reply. I managed to sort it thanks, sorry I forgot to press resolved.

Many thanks for code though, sounds like a good alternative

Lupson2011

[Robeen]

How did you solve it?
Someone might find your solution useful one day.

[Lupson2011]

Well,just used this code, which is very similiar to what you suggested..

=[Forms]![VolIncomeNotesMainForm]![U_Vol_Inc]

I realised that both the parent forms were working from the same table so could hook on the the value from there. If that makes sense. it works so am not complaining.

Have you seen my other thread in general access questions about extra records. if you have a solution for that, would be really grateful as it is confounding me at the moment lol

Lupson2011

[Robeen]

I DID see that but have never seen it myself so I didn't want to guess!!