Copy Paste txtbox not working

[Roscoe24]

I have a form (A) from qry A, with calc unbound txtboxes on of (Sum) (Avg).
Form (B) from qry B, needs same calc fields.
I've tried Copy/Paste which has copied the fields OK but on Form B they are calc [#Error].
Any clues anyone please?

 

[John Big Booty]

If both forms are not bound to the same Record Source, when you copy the formulas from one form to the other, you will get a #Error in your second form as the Control references are no longer valid. You will need to update those references to refer to controls on the current form.

 

[Roscoe24]

Thanks for your quick response - unfortunately I'd tried that. I had tried rebuilding the connection on Form B. Any other ideas?
The two source tables actually contain nearly duplicate data (but for different types of Leagues) so the unbound textbox on Form A : Control Source =Sum([BatRuns]) and for Form B is the same; one built against tbl/qry/frm League1 and the other built from tbl/qry/frm League2.

 

[John Big Booty]

Perhaps this article will help you resolve your problem.

 

[Roscoe24]

Many thanks for your help, John. I have put your article in favs and will check each thing out in turn. It's bound to be something I'll kick myself about when I find out what I've missed.