Why/how does the 2nd sub-form's source get changed when the Main form gets closed?
Toby ----- Original Message ----- From: "dreaux1" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, November 29, 2005 10:13 PM Subject: [AccessDevelopers] Sub-form name changes ? > 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 > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
