Form and Subform issues.

[Joceline]

I've created a form and subform using a a query on a conjuction table as this is a many to many relationship. the problem I'm having is that my subform will not allow me to update the field to add new information to the specific contact. if i add to the subform it updates the wrong table.
I'm not sure what I doing wrong, but I really could use some guidance on this.

 

[boblarson]

The subform should be based on the junction table. The values to select from should be from a combo box to select the values from the child side and the master side of the junction will be added automatically to that field if the subform's master/child properties are set correctly.

 

[Joceline]

thank you! i'll give this a try. My subform is based on the junction table, but the problem is that I want the name to appear instead of a number. how can i do this

 

[Joceline]

thanks. i did create the subform using the junction table, but i need for the "group" to show up as a name and not an ID number. how can i do this.

 

[boblarson]

thanks. i did create the subform using the junction table, but i need for the "group" to show up as a name and not an ID number. how can i do this.

Do you know how to have more than one column in a combo box's row source? You set it up so that you select both the ID and the Text (the row source query might need to use two tables within it and make sure you know I am talking about the COMBO's Row Source and not the form's record source) and then set the COLUMN COUNT of the Combo to 2 and then the COLUMN WIDTHS property of the combo to 0";2" and it should then show the second column (the Text) but be bound to the first column (ID)

 

[Joceline]

Thank you so much. I'm still skeptical as I can't believe my solution was so simple. but it's working!

I'm wondering if you'd be able to help me with an other function I'm trying to do.

here's the scenario: i have a contacts form which will update my junction table, thank you! now I'd like to be able to have it so when a new contact is entered, they select the drop down list for the association which will automatically fill in the associations address in the contacts info. I hope that this isn't too confusing and that you are able to help me.

Again, many thanks!