Solved Don't display EMF in Attachment control with data from subform

[AFila]

I can't display content of graphic file(EMF format) in Attachment control on main form.

Attacment's data source refer to field on subform. Maybe I specify wrong reference? On subform control Attachment displays image correctly.

I try different references for Attachment's control data source:

=[Form2].[Form].[FLAGS_EMF]

=[Form2].[Form].[FLAGS_EMF].FileData

Field [FLAGS_EMF] has type Attachment in database MS ACCEESS 2010

 

[arnelgp]

you can use a Query and use the Attachment column as Controlsource (bound) of the textbox.
or you can SaveToFile the Attachment and use Image Control to show the emf file.

 

[AFila]

you can use a Query and use the Attachment column as Controlsource (bound) of the textbox.
or you can SaveToFile the Attachment and use Image Control to show the emf file.

Thanks for answer. I think use method Attachment.SaveToFile is not good idea.
What do you mean "use Query"? Use another query in controlSource of main Form?
I would like get data for Attachment control on main Form from subform's query. Is it possible?

 

[isladogs]

According to MS Attach files and graphics to the records in your database - Access (microsoft.com), EMF files can be used in attachment fields.

Nevertheless, most developers recommend that attachment fields (a special type of multivalued field) should be avoided. Using them will embed files in your database causing the Access file size to rapidly increase and reduce performance. Instead store the paths to external files

 

[arnelgp]

there are two forms on the demo, BOUND_FORM and UNBOUND_FORM.
see the Current event of the SUBfrm.

 

[AFila]

UNBOUND_FORM - I understand. Thank you!
BOUND_FORM - gives Error: "Could not find field: IMAGE6"

 

[arnelgp]

sorry about that.

 

[AFila]

Thank you very much!

This is what I was looking for.