When I Add a OLEDocument to the CurrentRecord it works alright if strings are used:

However if I replace on of the Strings by a variable (String or variant) it does not work. Can anybody help?

Works:
maxrec.AddOLEDocument "File", "C:\myfile.doc", "MyDescription", 0, 0, 0, 0, 0

Does not work, but why?:
maxrec.AddOLEDocument "File", MyFile, "MyDescription", 0, 0, 0, 0, 0

Peter,

I'm not sure this helps but if your trying to insert Word documents have you tried our Max Doc add-on it the easiest way to do this ... without code!

see www.cabc.co,uk for a free trial version

Regards,

Ian Wallace CABC