jwcolby
jwcolby at colbyconsulting.com
Fri Sep 21 09:59:35 CDT 2007
Well now, that explains the why, which is what I was looking for. You got a response from A.D.Tejpal that indicated you could do what you were trying to do directly through control manipulation back in the subform. Have you tried that? John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Friday, September 21, 2007 10:33 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Leave Subform John, >> That is not plain English, that is database speak. With this audience...I'm pretty sure my explanation was simple enough. There is a a form...frmView. It has a subform...sfrmView. sfrmView is set to continuous. sfrmView has a textbox called Color. Color is used for conditional formatting.(1 highlights, 0 UNhighlights) The value stored in color is a number(0,1). When the user moves to a different record...the before update changes COLOR to 0.(which UNhighlights my record) The On Current changes COLOR to 1.(Highlights record) When you leave the subform...the before update fires...(UNhighlights my record) I am trying to find a way for COLOR to be set to 0 before moving to another record...but not when leaving the subform...or have it set to 1 when leaving the subform. Thanks, Mark ----------------------------------------> From: ----------------------------------------> jwcolby at colbyconsulting.com> ----------------------------------------> To: ----------------------------------------> accessd at databaseadvisors.com> ----------------------------------------> Date: Thu, 20 Sep 2007 ----------------------------------------> 16:27:18 -0400> Subject: Re: ----------------------------------------> [AccessD] Leave Subform>> ----------------------------------------> Mark,>>>I just want to change ----------------------------------------> a field in the subform to a ----------------------------------------> certain value when the> user ----------------------------------------> exits the subform.>> That is ----------------------------------------> not plain English, that is ----------------------------------------> database speak.>> I am trying ----------------------------------------> to discover what you are doing ----------------------------------------> so that I can suggest a ----------------------------------------> different> way of doing it. ----------------------------------------> What is the field? Why does it ----------------------------------------> need to be set when the> user ----------------------------------------> leaves the subform? What kind ----------------------------------------> of value will go in the field? ----------------------------------------> Is this> a "trail" of what the ----------------------------------------> user was looking at last?>> A ----------------------------------------> subform tries to save a record ----------------------------------------> being edited when you leave ----------------------------------------> the subform.> You are ----------------------------------------> intentionally editing the ----------------------------------------> subform record when you leave ----------------------------------------> the subform.> The subform ----------------------------------------> tries to save the record that ----------------------------------------> you just edited. A vicious> ----------------------------------------> circle...>> I would suggest ----------------------------------------> that you will need to store ----------------------------------------> the PK of the subform ----------------------------------------> "current"> record, then from ----------------------------------------> up in the main form run code ----------------------------------------> to update that record, some> ----------------------------------------> specific field. NOT EDIT A ----------------------------------------> FIELD ON THE SUBFORM, but ----------------------------------------> rather run SQL that> edits the ----------------------------------------> record back in that table. You ----------------------------------------> should be able to do that from ----------------------------------------> the> OnExit of the subform ----------------------------------------> control because SQL is editing ----------------------------------------> data in a table, not> ----------------------------------------> modifying a control on a ----------------------------------------> subform.>> John W. Colby> ----------------------------------------> Colby Consulting> ----------------------------------------> www.ColbyConsulting.com> ----------------------------------------> -----Original Message-----> ----------------------------------------> From: ----------------------------------------> accessd-bounces at databaseadviso ----------------------------------------> rs.com> ----------------------------------------> [mailto:accessd-bounces at databa ----------------------------------------> seadvisors.com] On Behalf Of ----------------------------------------> Mark A Matte> Sent: Thursday, ----------------------------------------> September 20, 2007 3:59 PM> ----------------------------------------> To: ----------------------------------------> accessd at databaseadvisors.com> ----------------------------------------> Subject: Re: [AccessD] Leave ----------------------------------------> Subform>> John,>> I'm ok with ----------------------------------------> the events in the subform ----------------------------------------> firing...>> Plain English...I ----------------------------------------> just want to change a field in ----------------------------------------> the subform to a certain> ----------------------------------------> value when the user exits the ----------------------------------------> subform. I don't want this to ----------------------------------------> happen when> they just move to ----------------------------------------> another record in the same ----------------------------------------> subform.>> Thanks,>> ----------------------------------------> Mark>>>>From: "jwcolby" ----------------------------------------> >>Reply-To: Access Developers ----------------------------------------> discussion and ----------------------------------------> problem>>solving>>To: "'Access ----------------------------------------> Developers discussion and ----------------------------------------> problem>>solving'">>Subject: ----------------------------------------> Re: [AccessD] Leave ----------------------------------------> Subform>>Date: Thu, 20 Sep ----------------------------------------> 2007 15:42:30 ----------------------------------------> -0400>>>>Mark,>>>>AFAIK this ----------------------------------------> won't work. The problem is ----------------------------------------> that when you change a record ----------------------------------------> on>>the sub form events in the ----------------------------------------> subform will fire.>>>>What are ----------------------------------------> you really trying to do, in ----------------------------------------> plain English?>>>>>>John W. ----------------------------------------> Colby>>Colby ----------------------------------------> Consulting>>www.ColbyConsultin ----------------------------------------> g.com>>-----Original ----------------------------------------> Message----->>From: ----------------------------------------> accessd-bounces at databaseadviso ----------------------------------------> rs.com>>[mailto:accessd-bounce ----------------------------------------> s at databaseadvisors.com] On ----------------------------------------> Behalf Of Mark A Matte>>Sent: ----------------------------------------> Thursday, September 20, 2007 ----------------------------------------> 3:21 PM>>To: ----------------------------------------> accessd at databaseadvisors.com>> ----------------------------------------> Subject: [AccessD] Leave ----------------------------------------> Subform>>>>Hello All,>>>>Have ----------------------------------------> an A97 db...I have a ----------------------------------------> subform/continuous...when I ----------------------------------------> leave/exit that>>subform I ----------------------------------------> want to change a value on the ----------------------------------------> current record of the ----------------------------------------> subform.>>I thought I could do ----------------------------------------> this by using the "On Exit" ----------------------------------------> property of the ----------------------------------------> subform.>>The>>problem is when ----------------------------------------> I click out of the ----------------------------------------> subform...the "on Exit" ----------------------------------------> does>>fire...but if I put code ----------------------------------------> in that references the field I ----------------------------------------> want to>>change...the click ----------------------------------------> part is cancelled and the ----------------------------------------> subform maintains ----------------------------------------> focus.>>>>Any ----------------------------------------> suggestions?>>>>Thanks,>>>>Mar ----------------------------------------> k>>>>P.S...I can't use the ----------------------------------------> "Before Update" of the subform ----------------------------------------> itself...because>>going to a ----------------------------------------> new record in the form does ----------------------------------------> something ----------------------------------------> different.>>>>________________ ----------------------------------------> ______________________________ ----------------------------------------> ___________________>>Kick back ----------------------------------------> and relax with hot games and ----------------------------------------> cool activities at the ----------------------------------------> Messenger>>Cafi. ----------------------------------------> http://www.cafemessenger.com?o ----------------------------------------> cid=TXT_TAGHM_SeptHMtagline1>> ----------------------------------------> >>>>-->>AccessD mailing ----------------------------------------> list>>AccessD at databaseadvisors ----------------------------------------> .com>>http://databaseadvisors. ----------------------------------------> com/mailman/listinfo/accessd>> ----------------------------------------> Website: ----------------------------------------> http://www.databaseadvisors.co ----------------------------------------> m>> ----------------------------------------> ______________________________ ----------------------------------------> ______________________________ ----------------------------------------> _____> Gear up for Halo. 3 ----------------------------------------> with free downloads and an ----------------------------------------> exclusive offer.> ----------------------------------------> http://gethalo3gear.com?ocid=S ----------------------------------------> eptemberWLHalo3_MSNHMTxt_1>>> ----------------------------------------> --> AccessD mailing list> ----------------------------------------> AccessD at databaseadvisors.com> ----------------------------------------> http://databaseadvisors.com/ma ----------------------------------------> ilman/listinfo/accessd> ----------------------------------------> Website: ----------------------------------------> http://www.databaseadvisors.co ----------------------------------------> m _________________________________________________________________ More photos; more messages; more whatever - Get MORE with Windows LiveT HotmailR. NOW with 5GB storage. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migratio n_HM_mini_5G_0907 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com