OK, I've now got the dropdown lists populated by putting a row sourse as a query against the source query for the form, but when I select a different author name, the subform does not change.
Do I need some kind of afterupdate code? Regards Pete --- In AccessDevelopers@yahoogroups.com, "Pete Harrison" <[EMAIL PROTECTED]> wrote: > > 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/
