Toby asks ... > Why/how does the 2nd sub-form's source get changed when the Main form gets closed?
I'm still trying to figure that :) It happens on it's own .. but not all the time. The source gets changed to the source of the other sub-form. Although the source name changes on its own, the linked fields don't, and since the linked field on the #2 sub form doesn't exist on the #1 sub-form table it prompts for a user intervention. So far I've classified it as the "don't mess with the data source" syndrome :) I'm just using the 2nd sub-form to display what's been picked via dropdowns on the main form. i'll get back to the problem later ... and will try (a)moving the picking process from the main form to the header part of sub-form #2, or (b)just do a pop-up for that function. For now, I'm programatically resetting the source name property of sub-form 2 when the main form closes ... so far that's working. The program is a recipe management system. Key words can be assigned to recipes, i.e. Color = Green, Texture = soft, good source Vit-C = yes, etc. The key words will be used by a menu development system to help narrow down options, and/or present best candidates for substitutions. In the problem form the key words are picked from dropdown lists on the main form and get added to an assigned- keywords table which is displayed in Sub-form 2. The sub-form (2) does permit some user interaction in that it's posible to remove/delete an assigned keyword. Sub-form #1 is basically unrelated to what sub #2 does. It's used to record alternative names for referencing ... i.e. "Mashed potatoes" and "Potatoes, Mashed" are the same thing. The only reason that Sun- 1 and sub-2 are on the same master form is because this master form is where all the cross referencing is defined. jeb ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/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/
