Alastair, you can use a single command file for all the eeps. --AllEeps.rmd SET VAR vRunItem TEXT = .%1 CLEAR VAR %1*
SWITCH (.vRunItem) CASE "delete" -- code BREAK CASE "add new" -- code BREAK ENDSW --cleanup code RETURN Jeff Ward <[EMAIL PROTECTED]> wrote: >Alastair, > >In answer to your first question, whenever I need a combo box to do >something more customized, that's exactly what I do - customize it. > >I place the appropriate var/column on the form and I have a .bmp of a small >down arrow that I place on a button right next to the field so it looks >just like a combo box. �The field may or may not be editable. �All of the >code goes into an eep run by the down arrow button. �With the appropriate >smattering of Recalc Var there is almost nothing you can't do. > >For your second question, it may just be the effects of a thick overcast >creating a dreary Chicago morning , but I do not follow exactly what you >are doing. > > >>Hi all, >> >>I have a couple of questions about how to do certain things on a form with >>which I'd appreciate some help, please: >> >>Firstly, I want to use a combo-box and supply the where & sort clauses for >>it from two pairs of radio buttons. >> >>The buttons work fine and return the variables I want and the combo-box >>returns the data from the table as expected. What I can't get to happen is >>for the where/sort clauses in the combo-box object properties to accept the >>variables from the buttons. The where simply gets ignored and the sort >>produces a syntax error. >> >>I can't be the first to try this so does anybody have a method that works? >> >>Secondly, I've been trying to get a form to do what I want it to do and seem >>to be (almost) failing miserably at the moment. I have got it to work but it >>seems such a convoluted method that I'm sure that I must be doing something >>wrong: >> >> >>I have two tables: one has 4 integer columns while the other has an integer >>column and a text column. The integer in the second table is a foreign key >>to two of the columns in the first table. Quite standard, nothing >>exceptional here. >> >> >> >>On the form I want, amongst other things, to have two variable fields that >>contain the text that is related to the relevant column in the first table >>which is also the form's only table. >> >> >> >>These two fields have pop-up menus that each summon the (relevant) text data >>from the second table. >> >> >> >>I want to avoid placing the IdNum columns on the form and my method uses 2 >>EEPs, one on row entry and the other on exiting each field. >> >> >> >>The first EEP gets the column values on row entry and puts them into >>variables and then gets the text to display in the form's fields. >> >> >> >>The exit from field EEP updates variables declared on the form which, in >>turn, update the table on row exit. >> >> >> >>At the moment this EEP updates every time a field is changed which is not >>efficient. I could have different EEPs for each field but that doesn't seem >>that clever, either. A row-exit EEP leaves the text unchanged while the >>form's in use which I also don't want. >> >> >> >>Is this the only way to do this or can anyone tell me what obvious mistake I >>'m making? >> >> >> >>I'll be grateful for any better suggestions. >> >> >> >>Thanks in advance >> >>Regards, >>Alastair. >> >>---------------------------------- >>A D B Burr, >>St. Albans, UK. >>---------------------------------- >>[EMAIL PROTECTED] >>---------------------------------- > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
