Combo Box Help

[Guest]

This is embarrassing and I have a feeling it's very simple. I have a table
with "Workstation" and "Description" fields. I would like to create two
combo boxes ("Workstation" and "Description") where selecting the
"workstation" will make the "description" pop up and vise versa. Any help is
appreciated. Thanks!

 

[Guest]

Hi Michelle,

Create a Combo Box with two columns to store the Workstation and description
from the Table.

Create a TextBox and set the ControlSource to combo1.Column(1) <Or whatever
you call the combo box>.

Each time you select a value from the Combo Box the TextBox will be show the
Description matching what you have selected.

Mark

 

[Guest]

Thank you...that worked. Could both boxes be set as a combo box so the user
can either filter on "Workstation" or "Description"? Right now with the
second box set as a text box, the user can only scroll down for the
"Workstation" and not scroll down for "Description". Thanks again.

 

[Guest]

Michelle,

There is no problem setting them both to Combo Boxes just repeat the code
for the second Combo Box and like you rightly said they could choose either.

Mark

 

[Guest]

Mark, can you tell me what I did wrong. I tried this code but it didn't work?

Workstation Combo box Control Source

"=[Description].[Column](2)"

Thanks.