Cannot Add a new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that pulls up information and a subform to add a note. I have
the subform set to add additions, data entry, etc. The subform is enter
directly into the table.

The note for the line item is matched with the MemberFID that is located in
both the master & child link and in both tables. The primary key is set to
no duplicates but the MemberFID is set to allow duplicates, as there could be
more than 1 note per MemberFirm.

I cannot get the note to show up in the table with the correct MemberFID.

What can I do to fix this?
 
If you have the DataEntry Property of the form set to yes, change it to no.
With yes it will let you enter new data, but wont let you see prev entries
 
I have tried the Data Entry property set to yes to accept new data but it
doesn't go anyplace. I go look in the table and it's NOT there.

I've tried setting the DE to no and it brings up the previous ones which I
can edit not a problem here. But I want to add a new one and I get this
message:
"The changes you requested were not successful because they would create
duplicate values in the index, primary key or relationship. Change the data
in the field or fields that contain duplicate data, remove the index or
redefine the index to permit duplicate entries & try again"

I have fix it so that it would accept duplicate entries (MemberFID). The
primary key is set with the AutoIDNum. And I still can't add a new record.
What is going on? Why can't I add a new record?
 
Check the table fields, check if any of them have Index(No duplicate)

Does this table has any relationship with other tables?
 
This is what I have in the table:

AutoIDNumber is a PK set to Index Yes (No Dups)
MemberFID is Yes (Dups OK)
Comments is Yes (Dups OK)
MNotesDate is Yes (Dups OK)
Initials is Yes (Dups OK)

This table has a relationship with MFMain. There is a query for the
viewing part pulling info from both of these tables. Just can't ADD to the
Notes table. I can edit a previous note but cannot ADD a new note.

Any ideas on how I can fix this?
 
Back
Top