From: Stefan Hoffmann on 1 Jun 2010 05:54 hi Bob, On 01.06.2010 10:53, Bob H wrote: > Then I copied and pasted the code above into a new module, but when I > come to save it, there is a compile error here: > > "ON FP.idUser = CU.idUser " & > "WHERE FP.FormName ='" & AForm.Name & "';" There is a line continuation sign missing after the ampersand. Change it to ..CU.idUser " & _ ".. mfG --> stefan <--
From: Bob H on 1 Jun 2010 06:19
On 01/06/2010 10:54, Stefan Hoffmann wrote: > hi Bob, > > On 01.06.2010 10:53, Bob H wrote: >> Then I copied and pasted the code above into a new module, but when I >> come to save it, there is a compile error here: >> >> "ON FP.idUser = CU.idUser " & >> "WHERE FP.FormName ='" & AForm.Name & "';" > There is a line continuation sign missing after the ampersand. Change it to > > ..CU.idUser " & _ > ".. > > > mfG > --> stefan <-- Still getting compile error: Compile Error Expected: line number or label or statement or end of statement. Thanks |