checkboxes & subforms problem

[urbe car via AccessMonster.com]

I'm working on simple home library project. There are tebles: book, author,
style... and author-book table (because of many to many relationship)

On the form: save_book have a subform with list of all authors (id, name...)
and checkbox for ewery author.The data is driven from a table.On the main
form are other books properties and button to save the book.

Sving the book is no problem, but selecting the authors of the book is.
Every book can hawe more then one author, but i cant get focus on any
checked checkbox . Did tried this with buttons too, but it's all the same.

Will be very happy for any sugestion (VB code, workaround ... anything)

picture of problem:
http://img.villagephotos.com/p/2005-4/988932/slikaaccess.jpg

 

[Allen Browne]

Presumably your book-author table has fields like this:
BookID relates to Book.BookID
AuthorID relates to Author.AuthorID

The subform needs to be bound to the Book-Author table (not the Author
table). The LinkMasterFields/LinkChildFields properties of the subform
control will cause it to show just the authors for the book in the main form
(based on BookID). Then provide a combo box in the subform for selecting the
author of the book. The RowSource of the combo will be the Author table. If
a book has 2 authors, select the first one from the drop-down list in the
first row, and then the 2nd author in the next record of the subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...