Hi,

I would like to include a list box on a subform but not sure of the best way to do this. Basically I have three tables

Users (userID, Surname, Given, etc...)
UserTypes (userTypesID, userID, typesID)
Types (typesID, type)

Users -- 1:M -- UserType -- M:1 -- Types

Basically I want to create a report that lists a user then automatically highlights the type (or types) of user they are in a list box. For example a user could be type tester and developer.

Further to this I would like to be able to select/deselect a type from this list box and update the tables accordingly.

Any thoughts would be greatly appreciated. If you need more info / better explanation please let me know.

Cheers,
Gus