combobox display item when not in list

  • Thread starter Thread starter Nick X
  • Start date Start date
N

Nick X

Hi all,
I have an application where combo boxes are filtered by groups (I have a
Group table and also a Level table). I also have a check box (yes/no field)
for Shared Project. For shared projects I need to display the item that is
in the combobox field.

Any suggestions would be appreciated.
Thanks,
Nick
 
Hi Nick,
you can use an unbound textbox.
Set its Control Source to
=[NameOfCombo].Column(1)
to get the name displayed in the combo if the combo's first column is
hidden.

Combos columns start numbering at 0. The first column is Column(0), the
second column is Column(1) and so on.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top