Useless error when setting a value

[daninthemix]

I have the following code:

[Forms]!components.[Serial Number] = [Forms]![serials]![Serial Number]

and get the attached error when it runs. Why?

The error is totally useless. I've checked my control names and everything is fine.

 

[Pat Hartman]

Forms do not store data. Tables store data. If you want to copy data from one form to another, both forms must be open. Are both forms open?

 

[daninthemix]

Yes, both forms are open.

 

[Pat Hartman]

You have a . which should be a !. Are you certain that the control references are correct? Both fields are on a main form?

 

[daninthemix]

Pat,

I solved this by changing the name of the control. I think it was an Access quirk, that by changing the name of the control to something other than the control SOURCE it was able to work. The fact that it was two words might not have helped. And yes - I tried all .s and all !s. Didn't matter.

Thanks

 

[Pat Hartman]

Perhaps there were more spaces in the name than you thought. The use of embedded spaces and special characters is considered poor practice. You will have less trouble if you stick with accepted naming practice.