Liveson, I'm sorry, my subsequent post did say that both forms were based on queries, not tables.
I wouldn't have thoguht the issues were different because it's a query not a table, but maybe I'm wring. Regards Pete --- In [email protected], "Liveson Tumbulu" <[EMAIL PROTECTED]> wrote: > > Pete > > Your initial post did not include ClientID which I suppose belongs to a third table. Then I think more information is needed for the members to help you better. How many tables are involved in this and what are their relationships? Until this information is available it may be difficult to figure out how a solution may be achieved. > > Good luck > > Liveson > ----- Original Message ----- > From: Pete Harrison > To: [email protected] > Sent: Thursday, October 13, 2005 12:56 PM > Subject: [AccessDevelopers] Re: Forms and Subforms > > > 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 > > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
