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