Liveson, Thanks for this.
The forms cannot be based on tables as information comes from multiple tables. I have a query for the main form which just returns Surname, PenName and ClientID. The subform has a query that includes AuthorID which is the link between the two queries/forms. The problem is that I need a dropdown list on the form that shows all the Surnames and another for the PenNames. When either of the entries in the lists is selected, I need the subform to update to the new records. Regards Pete --- In [email protected], "Liveson Tumbulu" <[EMAIL PROTECTED]> wrote: > > 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: [email protected] > 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 > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > ------------------------ 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/
