Albert, Without exiting the form for a particular MbrNumber the user can tab between panels and if a change was made a return to a panel where they made changes need to reflect the updated status.
I don't think using ON AFTER START eep can handle that situation. Jim Bentley, American Celiac Society 1-504-737-3293 ________________________________ From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, April 24, 2013 1:53 PM Subject: [RBASE-L] - Re: Where to imbed eep commands? I would go for the ON AFTER START eep for this code. Albert On 24/04/2013 12:51 PM, James Bentley wrote: > Where to imbed eep commands? > > I have a form "EdMbrInformation" > that contains multiple tabs as part of a Parent/Child > table structure. > > Parent table "MbrRegister" linking key MbrNumber > Subordinate tables: > MbrCurHomeInfo > MbrCurWorkInfo > MbrEmailInfo > MbrFaceBookInfo > MbrLinkedInInfo > MbrComment > > on each Panel Page there are six "bit" buttons > Close > Cancel > Refresh > Save > Delete > Add > > For any MbrNumber each of the Child Tables may contain > 0,1, or many rows. > > Depending on whether the form mode is Enter/Edit/Browse > certian buttons need to be ENABLED or disabled > For example > If the Child table contains 0 rows > Disable the Delete Button > Enable the Add Button > > I have devised the following code. > --- > SELECT COUNT(*) INTO FvMbrCmtCount FROM MbrCommentInfo WHERE > MbrNumber=.FvMbrRegMbrNumber > PROPERTY EGBMbrCmt_close ENABLED 'TRUE' > PROPERTY EGBMbrCmt_cancel ENABLED 'TRUE' > PROPERTY EGBMbrCmt_refresh ENABLED 'TRUE' > SWITCH(.RBTI_FORM_MODE) > CASE 'ENTER' > PROPERTY EGBMbrCmt_save ENABLED 'TRUE' > PROPERTY EGBMbrCmt_delete ENABLED 'FALSE' > PROPERTY EGBMbrCmt_add ENABLED 'FALSE' > BREAK > CASE 'EDIT' > PROPERTY EGBMbrCmt_save ENABLED 'TRUE' > IF FvMbrCmtCount = 0 THEN > PROPERTY EGBMbrCmt_delete ENABLED 'FALSE' > PROPERTY EGBMbrCmt_add ENABLED 'TRUE' > ELSE > PROPERTY EGBMbrCmt_delete ENABLED 'TRUE' > PROPERTY EGBMbrCmt_add ENABLED 'FALSE' > ENDIF > BREAK > CASE 'BROWSE' > PROPERTY EGBMbrCmt_refresh ENABLED 'FALSE' > PROPERTY EGBMbrCmt_save ENABLED 'False' > PROPERTY EGBMbrCmt_delete ENABLED 'False' > PROPERTY EGBMbrCmt_add ENABLED 'FALSE' > BREAK > DEFAULT > BREAK > ENDSW > RETURN > > My question is where should I embed the code? > * Table: ON ROW ENTRY > * Panel: ON TAB CHANGE > * Other location(s) > Jim Bentley, > American Celiac Society > 1-504-737-3293 > ------------------------------------------------------------------------ > ** > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com> > Version: 2013.0.3272 / Virus Database: 3162/6270 - Release Date: 04/24/13 >
