Question:
I am developing a radon database for the Ohio Department of Health with Oracle Power Objects. I have two combo boxes. First a choice is made from one of them, and in the second one, the values change according to that choice. I know Microsoft Access and Developer 2000, but the logic used in them is not working here. What I am missing?
Also, I am not able to create the main menu to open all the forms from that form-Main Menu. Help!
Answer:
There are two logical steps to solve your problem. The first step is tounderstand how to populate the values in a list box. Whenever you changethe value of the Translation property for a list box, the list boxwill repopulate itself.
The second step is to know when to repopulate the list box. The bestmethod to use for this is the Validate() method. Validate() is called whenever a user changes a value in anobject and leaves that object ? just the time you want to repopulate theother list box. You should put code in the Validate() method foreach of the list boxes to populate the other list box. I have two cautions about using the Validate() method. First, youwant to use the internal variable newval when setting theTranslation property, since the value of newval, as the nameimplies, is the new value for the list box. Secondly, make sure youexplicitly return True from the Validate() method, or else the focuswill be sent back to the object and the new value replaced with the old value.
