Why my query opens after running my code? Al 12/19/2008 3:59:01 PM I have a form that I use to send email using CDO method. The form has a list box with the multi select property is set to Extended. the code loops through the selections made in the list box then send the email. everything goes well except that the row source of the list box opens in the data sheet view after running the code. I have nothing in the code that tells it to open. The following code shows the only time that this query is mentioned: sql = "SELECT * FROM qryfrmEmail" Set db = CurrentDb Set rs = db.OpenRecordset(sql, dbOpenDynaset) any idea? thanks

Re: Why my query opens after running my code? "Dirk Goldgar" <dg[ at ]NOdataSPAMgnostics.com.invalid> 12/19/2008 5:44:11 PM "Al" <Al[ at ]discussions.microsoft.com> wrote in message news:7D823819-467D-4F05-906C-0C18A04DBFA7[ at ]microsoft.com... [Quoted Text] >I have a form that I use to send email using CDO method. The form has a >list > box with the multi select property is set to Extended. the code loops > through > the selections made in the list box then send the email. everything goes > well > except that the row source of the list box opens in the data sheet view > after > running the code. I have nothing in the code that tells it to open. The > following code shows the only time that this query is mentioned: > > sql = "SELECT * FROM qryfrmEmail" > Set db = CurrentDb > Set rs = db.OpenRecordset(sql, dbOpenDynaset) > > any idea? > thanks That code cannot open the query in datasheet view. Look harder for the code that opens the query. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)

RE: Why my query opens after running my code? JonWayn 12/20/2008 2:56:01 AM Put a break point or a Stop command at the end of your loop and you can step thru and see what statement gets executed when the datasheet opens "Al" wrote: [Quoted Text] > I have a form that I use to send email using CDO method. The form has a list > box with the multi select property is set to Extended. the code loops through > the selections made in the list box then send the email. everything goes well > except that the row source of the list box opens in the data sheet view after > running the code. I have nothing in the code that tells it to open. The > following code shows the only time that this query is mentioned: > > sql = "SELECT * FROM qryfrmEmail" > Set db = CurrentDb > Set rs = db.OpenRecordset(sql, dbOpenDynaset) > > any idea? > thanks