subform to display/gather attachments to records

A

Andy

I have a database with a main table containing records of issues and a linked
table containing attachments to the records in the main table. The
attachments are embedded OLE objects.
I have an entry form for the issue records that has a subform displaying all
the related attachment for each issue. All is fine EXCEPT, when you click on
the bound object frame for an attachment and view or update the object, then
try to navigate to the next issue record in the main database, the bound
object frame from the subform is the selected field in the next record. If
there is no attachment for the new record, and you attempt to point to a
different field or navigate to a new record, you get a warning message that
"The OLE object is empty. blah blah blah", and you must click "OK" to
proceed. If you then navigate to a new record with no attachment, this
happens all over again. How can I prevent this warning? It's very confusing
for users - I need to instruct them to move the pointer to a new field after
clicking OK and before moving to a new record. Thanks -
 
D

Dave

I would suggest that you move the focus to a control on the main form and
perhaps turn off the warnings.
Docmd.GoToControl (controlname)
DoCmd.SetWarnings True/False
 
A

Andy

Thanks, guess I need more help. I don't know visual basic, but mainly work
with property sheets - when would I go to the control? I tried using a macro
to set warnings, but I must not be invoking it at the right time, as it's had
no effect. Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top