Primary key changed value problem

T

ToniS

I am getting the following message when trying to add a record with in a sub
sub form.
"You can't update the record because another user or application deleted it
or
changed the value of its primary key" After the message the record is
added correctly.

My main form record source has select * from Exhibitors table
My subform has Select * from ExhbitorsShows table, Master and Child links
set to
ExhibitorID. There are no objects on this form (no textboxes, etc)

my sub sub form has select ERG.RepID, ES.ShowID, ES.ExhibitorID,
E.ExhibitorName, ERG.ExhbitorShowID. On this form I have a combo box and for
testing
purposes 2 text boxes that are bound to the ERG.ExhibitorShowID and ERG.RepID.
Child Link set to RepresentedID, Master link set to ExhibitorID.

Table Layouts
Exhibitor E
ExhibitorID
ExhibitorName
 

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

Similar Threads

Dynamic Naming of Form Button 3
Stored Procedure insert 2 tables w/ relationship of 1 to many 0
Select Left Outter Join 2
syntax Error or Access Violation 2
Can't seem to retrieve primary key number of newly created record in VB 1
Duplicate record in Form and Subform 0
Duplicate Record with Primary Key 1
Auto generating primary key number 1

Top