Just to close this particular question: It has taken a little time but I now have two forms which together enable me to make selections on the first form that are taken into account for the menu on the second form.
The first form is divided into 2 halves: the left has radio buttons and a text field which allows the user to make selections about the rows to be chosen along with the sort order for the combo-box menu on the second form. The right side has an image over which the second form is displayed when the user is satisfied with the selections. If a selection from the combo-box is accepted both forms close and the data is used. If the user is unhappy with the menu choices then escaping goes back to the first form for re-selection. An EEP on the first form (drops &) creates a temp view which is created with whatever conditions are entered on the form and the sort order, along with any pre-conditions determined before the first form is run, all pre-set in the view definition. Because the view is specific to any use of the form it also means that the combined forms can be used for almost every menu need where a simple (field) pop-up menu will not suffice and it also looks consistent every time. Apart from enabling a dynamic sort on the combo-box, the view also seems to be visibly quicker than the (sometimes) complicated where clauses involving other tables as well as the driving table from the combo-box properties (or any field pop-up menu). Thanks to everyone who offered help or suggestions - dreaming really works! Regards, Alastair. ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 6:31 PM Subject: [RBASE-L] - Re: A couple of Form how-to questions > As it happens, I have found a solution today but it's not perfect: by using > 2 forms I can create a temp view from the first form that is used by the > combo-box on the second form. The only thing wrong with it is the slight > flicker between the forms. With a bit more effort I can probably display the > second form positioned over a blank area on the first form which might be > more acceptable. > > Either way, the overall effect looks much better than dialog boxes and > pop-up menus that seem "out of character" with Windows look and feel - and I > had to be almost dragged screaming into RBWin!! > > Thanks & regards, > Alastair.
