Combo Box Help

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

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!
 
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
 
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.
 
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
 
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.
 
Back
Top