I'm trying to do a calculation but when I try to click of the line of code, I get an an error saying Compile error expected end of statement. What does this mean? This is the code:
When the error appears [sbfrmOrderLine] is highlighted so i'm assuming this error is something to do with it.
Thanks for the help
Code:
Forms![sbfrmOrderLine]![orderLineTotal] = Forms![sbfrmOrderLine][orderLineAmount] * Forms![frmNewCeilingProduct]![ceilingPrice]
When the error appears [sbfrmOrderLine] is highlighted so i'm assuming this error is something to do with it.
Thanks for the help