Populate calculated field

[Chi]

Hi,

Is there anyway to populate calculated fields like my text boxe in
form A to form B.

Thanks in advance.

Chi

 

[Jeff Boyce]

One approach might be to use something like:

Me!FormBControl1 = Forms!FormA!FormAControl99

using your form names and control names.

You could use this expression in Form B's OnLoad event.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chi]

Hi Jeff,

Thank you for your response!

Here is my work:

Under Form History's Onload event, I picked the Code Builder and entered
the expression below

Me!PercentageH = Forms!frminitial!Percentage.

I always have a message that Access cann't find the frmintial (form A). I am
sure that the Initial form in the database. But i cann't call it. ??

-------------------

I also tried to insert a textbox in the History form (form B) and named it
"PercentageH". At the PercenageH's ControlSource, I entered =
Forms!frminitial!Percentage. However, I got "NAME error"

Please advice

Thank you
Chi

 

[Jeff Boyce]

For that to work, both forms would need to be open and the frmInitial would
need to have a value in that field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chi]

Hi Jeff,

Thank you very much!

For that to work, both forms would need to be open and the frmInitial would
need to have a value in that field.

Regards

Jeff Boyce
Microsoft Office/Access MVP