I have a single table with names and addresses. I have a simple for that allows me to add new records and to save them. This all worked until I added an Attachment field to the table. I can add attachments to existing records. I can add records to the table. BUT when I add a new record to the table via the Form (I can see the record is there, the autonumber populates), when I try to save the record via me.requery or acCmdSaveRecord, the record is lost. If I remove the Attachment field from the table, then the form works again.
What am I missing? Many thanks for your wisdom.