I have a form with 2 sub-forms. When in run mode, and when the form gets closed, the source-object name of the 2nd sub-form gets changed automatically to the same source- object name as the other sub-form. So... when I fix the source-object name of the 2nd form so that it works ok, it works ok just once and then when the form closes, the source-object name gets changed and I get an error the next time the form loads.
I can probably work around this by having the previous form reset the code before opening the misbehaving form but that's maybe a bit too brutal :) Most of the activities on this 2nd subform are programatically generated from pick-lists on the master form, so like the user can make assorted picks from drop-downs and the picks get added to a recordset that serves as the data source for the second sub-form, which then gets requieried so that the user sees a list of what's been selected. It all works ok ... until the master form closes. Even then, all the dats files are like they should be. Apparently i'm doing something to annoy Access. John ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/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/
