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 ??

On Fri, 28 May 2010 16:43:47 -0700 (PDT), Jeffrey Marks <(E-Mail Removed)>
wrote:

>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 ??

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.
--

John W. Vinson [MVP]