Form based on Many-to-Many Relationship

I am trying to create a form based on a Many-to-Many relationship to enter
data into two tables. The table names are tblUser, tblGroup, tblJunction.
tblJunction has the primary keys of tblUser and tblGroup in it. The purpose
of the form is to be able to add a user to an already existing group that is
populated within the tblGroup. I am able to create the form but I am not
able to see any existing users or groups that are in the tables and when I
add either a new user or group the information is not saved to the table.
Any help that can be provided is greatly appreciated.

Create a form/subform. Base the main form on TblGroup and the subform on
TblJunction. Set LinkMaster/LinkChild to GroupID. Use a combobox to select a
user from TblUser. The combobox needs to be designed to have a value of
UserID. Write a procedure for the NotInList event to be able to add new
users to TblUser or use a command button to open a data entry form to add
new users. For the latter you will need to requery the combobox after add a
new user to make that user appear in the drop down list.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"Jerome" wrote in message
news
I am trying to create a form based on a Many-to-Many relationship to enter
data into two tables. The table names are tblUser, tblGroup, tblJunction.
tblJunction has the primary keys of tblUser and tblGroup in it. The
purpose
of the form is to be able to add a user to an already existing group that
is
populated within the tblGroup. I am able to create the form but I am not
able to see any existing users or groups that are in the tables and when I
add either a new user or group the information is not saved to the table.
Any help that can be provided is greatly appreciated.

Thank you for the help. That worked just fine. I couldn't find any
references to LinkMaster/LinkChild? But, I just created the combo box on the
subform and everything appears to be running fine. Thanks again.

"PC Datasheet" wrote:

Create a form/subform. Base the main form on TblGroup and the subform on
TblJunction. Set LinkMaster/LinkChild to GroupID. Use a combobox to select a
user from TblUser. The combobox needs to be designed to have a value of
UserID. Write a procedure for the NotInList event to be able to add new
users to TblUser or use a command button to open a data entry form to add
new users. For the latter you will need to requery the combobox after add a
new user to make that user appear in the drop down list.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"Jerome" wrote in message
news
I am trying to create a form based on a Many-to-Many relationship to enter
data into two tables. The table names are tblUser, tblGroup, tblJunction.
tblJunction has the primary keys of tblUser and tblGroup in it. The
purpose
of the form is to be able to add a user to an already existing group that
is
populated within the tblGroup. I am able to create the form but I am not
able to see any existing users or groups that are in the tables and when I
add either a new user or group the information is not saved to the table.
Any help that can be provided is greatly appreciated.