Thanks to Jeff putting the idea in my mind I've solved how to make the combo-box accept a dynamic where clause from a radio button variable:
It's actually easy and obvious - once the foggy brain clears: use an EEP to do a RECALC VAR before clicking on the drop-down arrow of the combo-box. I still can't get a dynamic sort to work, though... Regards, Alastair. ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 7:11 PM Subject: [RBASE-L] - Re: A couple of Form how-to questions > Hi Jeff, > > I can get what I want by other means - as you say EEPs, etc - but I was just > trying to use the combo box to make the form look a bit more "standard" and > I hoped that it would pick up my variables. I guess I'm just trying to do > too much. > > It's not _just_ your dreary Chicago morning - I was trying to explain > something without going into reams of print (can you have reams in e-mails?) > and lost some clarity. Let me try again: > > In it's simplest form I want a variable text field on my form that uses a > pop-up menu to obtain its data which in turn updates the integer column that > is not placed as a field on the form. The pop-up menu uses a table that has > an integer FK to the form table's column. > > The variable text field has to display the current data on entry to the row > then the changed data from the menu if popped up. > > For example, say that 2 rows in the form table integer column are: 100 & 200 > (along with other data); > and the pop-up menu returns Fred, Joe & Mike with idnums 100, 150 & 200 > respectively > On entry to row 1 on the form the text is shown as Fred. > The use then selects Joe from the pop-up which is displayed in the field and > then goes to the next row. > The form's table needs to be updated to 150 by some means and the next row > is displayed with Mike in the field. > > I can make it work but I felt my method was convoluted at best and I hoped > somebody (everybody?) would know a better way than mine. > > Thanks for your interest, > Regards, > Alastair. > > > > > ----- Original Message ----- > From: "Jeff Ward" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Monday, February 03, 2003 2:33 PM > Subject: [RBASE-L] - Re: A couple of Form how-to questions > > > > 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] > > >---------------------------------- > > >
