Jim DeMarco
Jdemarco at hshhp.org
Fri Apr 25 13:17:47 CDT 2003
Don, You can run an event from the record selector by putting the code in the form_click or form_doubleclick event. Private Sub Form_Click() MsgBox "hello" End Sub The message only appears if I click the record selector. Is this what you we're looking to trigger? HTH, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan -----Original Message----- From: Don Elliker [mailto:delliker at hotmail.com] Sent: Friday, April 25, 2003 2:12 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Events for continuous forms 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. Thanks for the help, 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):-> _D "Things are only free to the extent that you don't pay for them." >From: "Don Elliker" >Reply-To: accessd at databaseadvisors.com >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Events for continuous forms >Date: Fri, 25 Apr 2003 13:50:14 -0400 > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _____ Add photos to your messages with MSN <http://g.msn.com/8HMXENUS/2749> 8. Get 2 months FREE*. *********************************************************************************** "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". *********************************************************************************** -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030425/18d841ed/attachment-0001.html>