linking forms

[rg2005]

the titles a bit vague but im doing a library database and i have done everything except from the main part of a library which is taking a book out. So what i need to do is choose a specific member, then click a button that allows me to choose a book for that member, and then click another button that puts the members details and book detail into the loan table, so i can then issue the loan.

another thing i need to do is when a book is taken out, the 'available_in_library' check box needs to be unticked

thanks

 

[neileg]

I suspect that a form/subform set up will give you what you want.

 

[rg2005]

thanks for replying, but i cant see how a subform will help could you explain on this a bit more

this is basically what i need to do
http://www.access-programmers.co.uk/forums/showthread.php?t=19323
(second post) but i dont know how to do that

 

[rg2005]

i used a subform and got it working, but what i cant do is untick the checkbox 'available_in_library' when the book is taken out any suggestions