Access 2007 attachment control is out of control

axesdbpro · October 14th, 2010, 01:08 AM

I have a form that is related to a main form. Their relationship is in place.
The related form only opens through a button on the main form. The forms are tabbed.

When I start a new record on the related form, I have a problem.
On the first field when I enter the first character, sometimes the second field, which is an attachment field, displays an icon indicating that an attachment is present, and I haven't even clicked on the attm icon yet.
It's a new record. This is driving me nuts.

I click on the attachment and have to remove the file manually. I suspect that some attachments that were deleted while testing, have not been properly disposed of, and Access keeps them internally in a hidden file.

Help will be appreciated.

HiTechCoach · October 14th, 2010, 01:53 AM

I would make sure that the sub form is showing the correct related records.

axesdbpro · October 14th, 2010, 02:49 AM

Thanks Coach. Yes, it shows correctly the related records; I am using on-activate event when switching back to the related form.

I may have found the solution; still testing though. Two things I did to the main form:
a) No longer do I have the (only) subform disabled, which would be enabled according to events.
b) No longer do I use KeyPreview, which I was using for keyboard user's convenience.

And in the related form:
a) Took the first 2 lines out the macro when related form was deactivated:
Condition Action Arguments
[newrecord] And Not [Dirty] CancelEvent
... StopMacro
RunCommand SaveRecord

and just kept the SaveRecord command.

UNKNOWNS
Don't know why the KeyPreview setting to Yes on main form, creates problems with attachments.
Or, was it the subform being disabled and enabled again at some point.

If I find it's not enough, I'll come back here in a hurry again.
Thanks Coach.

axesdbpro · October 24th, 2010, 04:54 PM

Hello everyone,

This is just to seal the hanging thread.

I finally found the real cause for the attachment field misbehavior.

As you know, the attachment icon was having some 'intruder' files that
attach to the field, unsolicited. When I started a new record on this related form, and typed a character on a regular field, sometimes the attachment field would present an attached file out of nowhere.

The cause was the filter that was being applied on a new record.

On an existing record, the filter should be applied to display the corresponding record, but not when a new record is being created.