Changing values

  • Thread starter Thread starter Jeffrey Marks
  • Start date Start date
J

Jeffrey Marks

I have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together, tblAttendees that holds the EventID
and MemberID.

Recently, the MemberID of the tblAttendees changed on 2 records in the
table. I can see the before in an earlier version of the database and
can see what changed in the current database. It appears to be the
first event in the tblAttendee which is changing when a new member is
added. Am I doing something wrong or ??
 
I have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together, tblAttendees that holds the EventID
and MemberID.

Recently, the MemberID of the tblAttendees changed on 2 records in the
table. I can see the before in an earlier version of the database and
can see what changed in the current database. It appears to be the
first event in the tblAttendee which is changing when a new member is
added. Am I doing something wrong or ??
Click to expand...

One way this can happen is if you have a Combo Box on a form with the purpose
of selecting which record to view; such a combo *should* be Unbound (nothing
in its control source). If you use a Bound combo, it will overwrite the
Control Source with whatever ID is selected when the user tries to search.
 
Back
Top