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 he

"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 --