Restrict the users to insert an object from a existing file only?

[mtabt]

My table contains a field that is a bounded frame object.
I have a command button that users can click to insert any object they like. However, is there a way to restrict the users to insert an object from a file rather than new..??

By default, a dialog comes up asking if you want to insert an object by "create new" or "create from file". I only want to allow users to "create from file". This will cause less confusions.

Thank you very much, any help will be appreciated.

 

[Aivars]

Hi!

OLE1.OLETypeAllowed = acOLELinked
OLE1.Action = acOLECreateLink

or

OLE1.OLETypeAllowed = acOLECreateEmbed
OLE1.Action = acOLEEmbedded

Open your codes window, click on word &quot;Action&quot;, press <F1>

Aivars

 

[mtabt]

Thank you for help. However, your suggestions do not help me.

I want the user to determine the location and type of file he/she wants to attach.

Using your method I have the specify the &quot;SourceDoc&quot; and &quot;Class&quot; of the attachment.

I want to open the option to the user.

If you can find anything else, I will appreciated. Thank you.