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] > >---------------------------------- >
