Yes

And I want it to display the RoleName in the field, and when you add another Role, clicking on the cell shows a dropdown with the Roles in it. (Now to be clever it would be nice to have those roles already assigned, excluded from the list:-))

dude... i think you should VBA this... I have had instance where i used subforms to show attributes of an entity... the way i added additional attributes was using VBA to copy the ID value in the main form to the ID value field in the subform... I belive i used the BeforeUpdate event (i may be wrong)... do you have any clue as to how to go about doing this?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."

quick try..... have you tried to set the 'default value' property of the idUser textbox (you should have this, even if you have to hide it) to the idUser on the main form. ei. Forms![MainForm]![idUser]

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."

dude... i kind of replicated your database and form... my previous suggestion seems to work just fine, and you don't need any vba... what's ur status?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."

Hi

Well I think I got it working, I dragged & dropped the table onto my main form and let Access figure the links, and edited the subform that was created to give me the dropdowns, but not 100% sure on what I did.

I have another subform now for courses the user has been on, so hopefully things will gell then.

Thanks for your help.

Andy