Access Form Issue

[GerardT]

I have created a Relational Database with four Lists linked to an input form.
The link for all is the autonumber ID number. The form works fine with
selecting data from any of the lists via a drop down menu using the ID from
each list.

But, when I put an attachment picture into the form Access tries to open a
new record in the file with the attachment picture. If I select an existing
record on the form the picture shows up fine and can even be changed. But
when I try to enter a new file using a ID from one list. And then try to
select a record from another list (with the attached picture) it tries to
open a new record by showing the next available blank ID.

If I remove the picture from the form works fine again. And If I input the
attachment using the table view it also works fine. I just can't get it to
work using the form itself.

Any Suggesstions??

 

[GBA]

you write " put an attachment picture into the form "

One can not understand the meaning of this phrase. One puts data (text,
number or dates) into a field of a form.

What is an 'attachment' picture? Why are you attempting to put an image into
a field of a form?