Look at the properties of the subform control on your mainform. Do the Link Child Fields and Link Master Fields properties contain values that would link the mainform to the subform? From your description, it sounds as though this should be authorid. I'm not an expert, but this is the first thing I'd check. Hope this makes some sort of sense! Cheers Cathy
-----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Pete Harrison Sent: 13 October 2005 11:17 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Forms and Subforms 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 ------------------------ 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/
