Populate calculated field

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

Hi,

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

Thanks in advance.

Chi
 
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
 
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
 
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
 
Hi Jeff,

Thank you very much!

Jeff Boyce said:
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
Click to expand...
 
Back
Top