dbTalk Databases Forums  

Unbound object frames showing blank

comp.databases.ms-access comp.databases.ms-access


Discuss Unbound object frames showing blank in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Phil
 
Posts: n/a

Default Unbound object frames showing blank - 08-26-2010 , 04:03 AM






I have an Unbound object frames called letter

The routine below runs on the OnCurrent of the form.
The CheckFileExists(DocID) returns true or false if it finds the document

If CheckFileExists(DocID) = False Then
With Letter
.SourceDoc = ""
.OLETypeAllowed = acOLELinked
.Enabled = True
.Locked = False
.Action = acOLEDelete
.Action = acOLEUpdate
.Action = acOLEClose
.Requery
End With
Exit Sub
End If

What I want to happen is to show an empty frame if the document cant be
found, but it continues to show the picture of the last document successfully
retrieved.

The various .Action bits were tries that didn't appear to help

Phil

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.