Two combo boxes in form whose control source and row source are the same

[MichaelA]

I'm working on a Library database and many of the books have co-authors. In my "Books" form, I need two combo boxes that both get their information from the "Authors" table and the form writes Title, Author, CoAuthor (If there is one) and Location to the "Books" table. The problem is, when I select an author in one combo box, it fills in the second combo box with the same author. When I select another author in the second combo box, the first combo box copies. How can I set up the two combo boxes so I can select two different authors from the same table and have them written to the "Books" table, one as "Author" and one as "CoAuthor"

Thank you!

[Gicu]

You simply bind the first one to the Author field and the second one to the CoAuthor one. So in your Books table you have two fields (Author - short text or AuthorID - long and CoAuthor or CoAuthorID) and the two combo boxes would have their row sources "SELECT AuthorID, Author FROM AUTHORS ORDER BY Author;" with Column Count=2 and Column Widths 0";3".
Cheers,

[MichaelA]

You simply bind the first one to the Author field and the second one to the CoAuthor one. So in your Books table you have two fields (Author - short text or AuthorID - long and CoAuthor or CoAuthorID) and the two combo boxes would have their row sources "SELECT AuthorID, Author FROM AUTHORS ORDER BY Author;" with Column Count=2 and Column Widths 0";3".
Cheers,

I'm not sure I understand. How does that draw from the "Authors" table.

Sorry, I'm a newb.

[Gicu]

The row source (that populates the combo) is from the Authors

SELECT AuthorID, Author FROM AUTHORS ORDER BY Author;

, but you store the IDs (or author's name) in two fields in the Books table.

Cheers,

[MichaelA]

The row source (that populates the combo) is from the Authors , but you store the IDs (or author's name) in two fields in the Books table.

Cheers,

Thank you! That did it. I appreciate your help!