I have two tables training class and users, and a junction table user-class.
I tried creating a combo box on my users form which would list the available
classes from the training class table, and upon selecting a class the
selected user will be placed in that class. It did not work.
I selected columns CLASS ID, CLASS NAME, START DATE, END DATE,
EDUCATOR,TRAINING ROOM, all fields from the training class table. I chose
Class ID as my unique ID. when i select a value, I receive a message,
'cannot be edited bound to column class Id.'
What I am I doing wrong? Please help
Arvin Meyer [MVP] - 30 Apr 2008 03:48 GMT
Examples of how to do exactly what you'd like are at:
http://www.accessmvp.com/Arvin/ManyToMany.zip

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
>I have two tables training class and users, and a junction table
>user-class.
[quoted text clipped - 9 lines]
>
> What I am I doing wrong? Please help
CCarter - 28 May 2008 04:39 GMT
Thank you so much. Everything works great.
> Examples of how to do exactly what you'd like are at:
>
[quoted text clipped - 12 lines]
> >
> > What I am I doing wrong? Please help