Prev: change cell color
Next: Thanks
From: Jeffrey Marks on 28 May 2010 19:43
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 ??
From: PieterLinden via AccessMonster.com on 28 May 2010 21:13
Jeffrey Marks 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 ??

Not something I have ever seen. How are you entering your records? Do you
have Forms based on Outings and Members, each with a subform based on
Attendee? Do you have any code behind your forms? Something here just
doesn't sound right.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201005/1

From: John W. Vinson on 28 May 2010 23:49
On Fri, 28 May 2010 16:43:47 -0700 (PDT), Jeffrey Marks <jeffrmarks(a)gmail.com>
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]
 | 
Pages: 1
Prev: change cell color
Next: Thanks