Re: [AccessDevelopers] Forms and Subforms

[Liveson Tumbulu]

Pete   I think basically you have two tables one for authors and the other for books. Create one query which should include AuthorID, Books, etc. Then create a form bound to this query. You may not need a query after all. The form may simply be bound to the Books table with selected fields.   Create an unbound form and on it place a combo box named say cmbAuthorID , then place the first form on it. The combo box should lookup the values from the Authors Table and not the query. The combo box may have fields like AuthorID, Surname, FirstName, Penname (from the Authors table) but the bound field is AuthorID. Set the Link Master and Link Child fields to AuthorID (AuthorID is the primary key in Authors table and a foreign key in the Books table and should be present in the subform). You may create another text box or label that displays Author's full names on the parent form once the combo box gets updated. This should work for you.   Northwind database sample has very good examples of subforms.   HTH   Liveson   ----- Original Message ----- From: Pete Harrison To: AccessDevelopers@yahoogroups.com Sent: Thursday, October 13, 2005 11:40 AM Subject: [AccessDevelopers] Forms and Subforms I cannot seem to do something that should be so easy. I want a form with a subform The main form wants a dropdown list of author surnames and their pen names. The subform needs to display a list of books they have written. I have a query that creates a list of all books sorted by authorID for the subform and a quert that creates a list of author surnames, pen names (if they have them) and authorID. What I end up with is a dropdown which only show 1 author and record navigation to move to the next author. Where am I going wrong? Regards Pete ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to:     http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to:     [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to:     http://docs.yahoo.com/info/terms/   Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.