Search results

hi all Can you help with this one please? This works CurrentDb.Execuite "UPDATE Table1 SET Table1.Status = 2 WHERE Table1.orderNumber ='632';" This wont work CurrentDb.Execuite "UPDATE Table1 SET Table1.Status = 2 WHERE Table1.orderNumber = varItem1;"

Hi all I am a self taught programmer started on PHP now use access at work and have attended a beginners course. Looking forward to using and learning about access. Regards Barry