Drop down box in contiuous form or ds view

[SAC]

How do you handle a dropdown box in a continuos form. I'd like to select an
inventory category and then have a second dropdown box to display the items
of inventory in that category. But when I change category all the dropdown
boxes change to it.

So how do you handle this?

Thanks

 

[John Vinson]

How do you handle a dropdown box in a continuos form. I'd like to select an
inventory category and then have a second dropdown box to display the items
of inventory in that category. But when I change category all the dropdown
boxes change to it.

So how do you handle this?

Thanks

One way to do so is to superimpose a Textbox carefully over the text
area of the combo box which goes blank. Its properties should be
Eanbled = No, Locked = Yes, Tab Stop = No; it should be bound to the
field you want displayed, or to a DLookUp expression returning that
field. When you select the combo downarrow or tab into the combo, it
will "pop" in front of the textbox and let you select a value
appropriate for the chosen category.

John W. Vinson[MVP]

 

[Guest]

You'll find a demo I produced of this at:

http://community.compuserve.com/n/p...yMessages&tsn=1&tid=23626&webtag=ws-msdevapps