Linking two sets of data to one form...HELP

[a14929]

I am in the process of designing an appliction to assign books to students. On the students form, I have included the various fields from the students table. The students table is therefore the record source in the properties dialog box. However, on this form, I also need to include a checkbox "Yes/No" field from the books table. Is there a way of doing this? I am desperate, plese help!
Hvr, I do not want to create a subform to do this. I just want a checkbox that links to a different table. HELP!

 

[S]

The only way I know to write something in two different tables using one form is to link the tables (in a query) using a common field (eg Student's name) and define the query as form's datasource.
If you are able to use code yuo need common field for linking the tables, too.
Bye, S.

 

[a14929]

Thanx S.