Data from one subform to anther subform

[scotribs]

Hi All,



I have uploaded a screen shot as I believe it will be easier to explain what I want to do.

I have tried several different codes here and just can't get it to work.

Thanks for any help in advance.

[RuralGuy]

Perhaps this link will help: http://www.mvps.org/access/forms/frm0031.htm

[scotribs]

Thanks for posting the link, unfortunately it didn't work. It is probably something I'm doing as I'm new at creating databases. My code looks like the following using the table from the link

Me![Quality Paint Results].Form.[Tag Number] = Me![Tag No]

This code is in the 1st subform Casting Log.

[RuralGuy]

Try going through the Forms collection for all of the references as a test.