Problems with database

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles:

About

DevX is the leading provider of technical information, tools, and services for professionals developing corporate applications. 

Subscribe

Get exclusive access to the best technical information, tools, and services sent straight to your inbox.  

©2023 Copyright DevX - All Rights Reserved. Registration or use of this site constitutes acceptance of our Terms of Service and Privacy Policy.