An error number : 424 problem

[ericb]

I'm having trouble with an attachment field.

On a report I can see the picture and the filename of the selected attachent
properly.

Now in a SQL UPDATE string that i'm making I always get the error 424 Object
required.

Here is the line where it happens :

'mySQL = mySQL + ", scan_g = " & prn_du_pied_g.FileName

scan_g is a Text field
prn_du_pied_g is an attachment

All I want to do is to use the filename of the attchment.

How do I solve this

Thank you for the help

 

[De Jager]

I'm having trouble with an attachment field.

On a report I can see the picture and the filename of the selected
attachent
properly.

Now in a SQL UPDATE string that i'm making I always get the error 424
Object
required.

Here is the line where it happens :

'mySQL = mySQL + ", scan_g = " & prn_du_pied_g.FileName

scan_g is a Text field
prn_du_pied_g is an attachment

All I want to do is to use the filename of the attchment.

How do I solve this

Thank you for the help