Why doesn't my embedded object update?

[martlewis]

If I edit a bitmap image that's embedded directly within a table all works fine. I can double click on it, paint opens and any changes are saved within the table.

When using a form to edit records all changes to records save fine except if I've edited the embedded bitmap. It just doesn't save.

Has anyone any ideas why?

Thanks.

 

[martlewis]

Ah, get round it by using the following code...

With Forms.Item("Invoices").Controls.Item("Signature")
.Locked = False
.Enabled = True
.Action = acOLEActivate
.Verb = acOLEVerbOpen
.Locked = True
.Enabled = False
End With

The code executes when I click on a button.

How do I make it wait until after I close paint before it locks and disables the object again? I need a way of knowing when paint is closed.

 

[boblarson]

Just lock it in the form's On Current event.

 

[martlewis]

Just tried to lock it using the forms On Current event. That works fine when the form is first opened but after closing paint and going back to the form that was open when I launched the ole object it doesn't got through the oncurrent event.

 

[boblarson]

Just tried to lock it using the forms On Current event. That works fine when the form is first opened but after closing paint and going back to the form that was open when I launched the ole object it doesn't got through the oncurrent event.

I don't know of a way to immediately lock it when you come out of Paint. There are no events which fire when that happens so the best that I can think of is just that when you move to the next record it will then be locked again.