Either/Or Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My boss wants one of our data entry forms to have two drop down boxes of
which the user can use one or the other (one's for external and one's for
internal suppliers). I have it going OK, but I need a way to not show the
contents of one combo box contents if the other one has the focus(box is
there but blank). I've tried everything I can think of but so far so bad.

Thanks,
Lorna
 
How do you determine whether the supplier is internal or external?
If you can do this at the point where you open the form, set the appropriate
drop down to visible = false and the desired drop down to visible = true.
 
okay, these are bound combos. this is one reason I don't bind combos, but
that is another story. You could change the font color to the same as the
back color :)
 
You're semi- right. I tried using null on got focus for the other combo and
it worked, but since both combo boxes are bound to a database field, if one
changes they both change. I need to make the text white like the background
or something that just makes the field invisible.
 
Okay, that did it. I unbound the two combo boxes and put in a text box
showing which one had been chosen....that one is bound. Works great! Thanks.
 
Back
Top