I think I have expereinced something similar a while ago. I remember having to reset the recordsource of the subform (in code) as a way of requerying it. This seemed to 'refresh' it everytime with the correct data.
HTH, Angelo ----- Original Message ----- From: David Pearson [mailto:[EMAIL PROTECTED] Sent: 9/20/2005 7:23:18 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Strange Things Are Happening > *****UPDATE***** > > I added a manual refresh button to my main form. When the pop-up closes the > sub form is still empty. Quick fire clicking of the refresh button makes > the stock code appear in the sub form after a couple of seconds. This > suggests a time delay on writing the file to the table. The thing is that I > have a remove button on my main form, when I highlight the stock code in the > sub form and click the remove button it removes it instantly so there is no > delay there. > > Again this only happens in start-up mode or in the MDE. > > Regards > > David > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of David Pearson > Sent: 20 September 2005 10:04 > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] Strange Things Are Happening > > Hello all, > > I have a large application that I am continually developing. This problem > is a little annoying. > > I have a form with a sub form. I have a button which opening another pop-up > form that lists stock codes, a code is selected from the list and a button > is clicked. This runs some SQL that appends data top a table (the same > table that the sub form on my main for is based on. After the SQL I requery > the sub form and close the popup. The stock code selected is now in the sub > form. > > Now with no intervention from my I now have users complaining that the stock > codes aren't being added. I investigated and found that they are actually > being appended by the SQL but the sub form is not being refreshed. Upon > further investigation I found this only happens when in startup mode on the > MDB file (i.e. I have hidden the database windows and other things) and in > the MDE I create for distribution. If I open the MDB with [Shift] key down > (i.e. full access the everything) and try the form it works perfectly. > > This was all working fine, even in the MDE. I changed another no related > part of the app and redistributed to my users and then this started > happening. > > Aaaaarghhhhh! I hate problems like this. > > Regards > > David > > > > > > ============================================================= > The information in this Internet email is confidential and intended for the > sole use of the addressee(s). Copying, disclosure or re-use, in any way, of > the information contained in this email by anyone other than the addresse(s) > is unauthorised. We accept no legal responsibility for the content of this > message. Any opinions or views presented are solely the responsibility of > the author and do not necessarily represent those of Siddall and Hilton Ltd. > and any of their subsidiary companies. If you have read this email in error, > please return it to the sender and remove from your system. > Siddall and Hilton Ltd. and any of their subsidiary companies may monitor > the content of emails sent and received via its network for the purposes of > ensuring its compliance with its policies and procedures. > ============================================================= > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star. The service is powered > by MessageLabs. For more information on a proactive anti-virus service > working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > > ------------------------ 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 > > > > > > ============================================================= > The information in this Internet email is confidential and intended for the > sole use of the addressee(s). Copying, disclosure or re-use, in any way, of > the information contained in this email by anyone other than the addresse(s) > is unauthorised. We accept no legal responsibility for the content of this > message. Any opinions or views presented are solely the responsibility of > the author and do not necessarily represent those of Siddall and Hilton Ltd. > and any of their subsidiary companies. If you have read this email in error, > please return it to the sender and remove from your system. > Siddall and Hilton Ltd. and any of their subsidiary companies may monitor the > content of emails sent and received via its network for the purposes of > ensuring its compliance with its policies and procedures. > ============================================================= > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > > > > 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/A77XvD/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/
