<html><div style='background-color:'><DIV>
<P>Jim</P>
<P>Well, thanks for making me look like a complete idiot....You are absolutely correct sir! On both counts. Thanks (again). Sometimes I think I picked the wrong profession.</P>
<P>Have a most excellent weekend all!<BR>_d<BR></P></DIV>
<DIV></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Jim DeMarco" <JDEMARCO@HSHHP.ORG>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>>Date: Fri, 25 Apr 2003 14:17:47 -0400
<DIV></DIV>>
<DIV></DIV>>Don,
<DIV></DIV>>
<DIV></DIV>>You can run an event from the record selector by putting the code in the form_click or form_doubleclick event.
<DIV></DIV>>
<DIV></DIV>>Private Sub Form_Click()
<DIV></DIV>>MsgBox "hello"
<DIV></DIV>>End Sub
<DIV></DIV>>
<DIV></DIV>>The message only appears if I click the record selector. Is this what you we're looking to trigger?
<DIV></DIV>>
<DIV></DIV>>HTH,
<DIV></DIV>>
<DIV></DIV>>Jim DeMarco
<DIV></DIV>>Director of Product Development
<DIV></DIV>>HealthSource/Hudson Health Plan
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Don Elliker [mailto:delliker@hotmail.com]
<DIV></DIV>>Sent: Friday, April 25, 2003 2:12 PM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Replying to my own email...I need a life. Anywho, still no soap. It looked good but for what I want, it looks like it can't be done. When the user selects a record (with the record selector) then clicks the 'update' button (mine) If there is a selected record, I want to update just that record(s). If there isn't a selected record, I will update all records on the continuous form. I thought the Sel functions would do it, but in my case, SelHeight and SelWidth are always zero, SelTop has the selected record number or record 1 if none are selected (really, the way it looks is that something always qualifies as 'selected'). I believe the Record Selector is a beast unto itself and may not expose anything I can use.
<DIV></DIV>>
<DIV></DIV>>Thanks for the help,
<DIV></DIV>>
<DIV></DIV>>PS -maybe I need to mention how easy this would be to do UnBound to get everybody weighed in and solve this (kidding of course):->
<DIV></DIV>>
<DIV></DIV>>_D
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>"Things are only free to the extent that you don't pay for them."
<DIV></DIV>>
<DIV></DIV>> >From: "Don Elliker"
<DIV></DIV>> >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> >To: accessd@databaseadvisors.com
<DIV></DIV>> >Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>> >Date: Fri, 25 Apr 2003 13:50:14 -0400
<DIV></DIV>> >
<DIV></DIV>> >_______________________________________________
<DIV></DIV>> >AccessD mailing list
<DIV></DIV>> >AccessD@databaseadvisors.com
<DIV></DIV>> >http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>> >Website: http://www.databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>> _____
<DIV></DIV>>
<DIV></DIV>>Add photos to your messages with MSN <HTTP: 2749 8HMXENUS g.msn.com>8. Get 2 months FREE*.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>***********************************************************************************
<DIV></DIV>>"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You".
<DIV></DIV>>***********************************************************************************
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMXENUS/2743">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html>