"Noemi" wrote:

Hi Mike
Unfortunately I still get the following error.

'Operration is not supported for this type o fobject'

Any other ideas???


Does it help if you change this line:

Set rs1 = db.OpenRecordset("tbl_Head_Office_Stock")

to:

Set rs1 = db.OpenRecordset("tbl_Head_Office_Stock", 2)

--
urkec