copying subform syntax error

[mike2000]

I wonder if someone could spare a minute to help me with my syntax error, i have tried all the variations i can think of, but i still get a 'runtime error 2465' access can't find the field 'forms' refered to in your expression. the code still copies the data over, so would it be ok to just suppress the error message?

[Forms]![FrmOrder2]![Forms]![SBFRMOrder2] = [Forms]![FrmOrder1]![Forms]![SBFRMOrder1]

?

Thanks

 

[KevinM]

You are miss a reference to a control on your subforms and added an extra '[Forms]' by mistake.

Try....

[Forms]![FrmOrder2]![SBFRMOrder2] ![MyControl]= [Forms]![FrmOrder1]![SBFRMOrder1] ![MyControl]

 

[mike2000]

Its the contents of the whole subform im copying, i thought that was the control?. The subform is based on a query, i tried that name , but i guess it was wrong as it also came up with the same error message. I'm a little confused as to what the control is if i'm copying the subform.

 

[KevinM]

What exactly are you copying the 'contents' of the suform to?

What is your goal?

 

[mike2000]

I'm copying the contents of the subform to another subform. This is happening, which is confusing why it comes back with an error.