Actually a combination of things. 1) Upon exiting the 1st field verify its setting via code 2) Display the second field only when the appropriate setting is selected 2) Automatically go to the second field upon exit of the first field (note do not necessarily require a value be inputted in case they wish to change the value of the 1st field). 3) Before closing the page/form (whatever) make sure your verification routine verifies that all aspects of the page are complete and all rules have been adhered to. Of course if you have tied this page directly to the database that might prove to be problematic --- but then tying any page directly to the database (in my opinion) has numerous problems that tend to get overlook.
--- On Fri, 4/3/09, Joe <[email protected]> wrote: > > I have a form that has a drop down field called Input_Type that has a list > for Project or > Discretionary. > > I also have another field on the form that is Capitalizable Y/N. > > I need to make the Capitalizable Y/N drop-down required if they select > Project from the > Input_Type drop down. > > What is the best way to go about this using VB? > [Non-text portions of this message have been removed]
