This site should help, scroll down to Cascading Combo Boxes http://www.candace-tripp.com/pages/access_downloads.aspx
Ed Tesiny [EMAIL PROTECTED] > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of bunkyfoly > Sent: Monday, July 18, 2005 1:19 PM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] Combo Box Synchronization - Main > Form to Subform? > > Have main form containing one subform. Both bound to linked tables. > Main form has Combo Box A set to "display a RECORD on subform, based > on selection in Combo Box A." Works great-does just what I want to > this point! At the same time a RECORD selection is made from Combo > Box A, I want, also, to have Combo Box A to SYNCHRONIZE with Combo > Box B in the subform and to display a value in Combo box B based upon > the SAME value selected in Combo Box A (that selects the record). Have > tried several things to get synchronization between Combo Boxes A and > B; have searched Access Newsgroups/Knowledge bases without success. > Am using MS Access 2002, producing Access 2000 database. Has anyone > got any ideas? Could really use some help. Thank-you! > > Bunky > > > > > > 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 <*> 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/
