Display description

  • Thread starter Thread starter Angela Byars
  • Start date Start date
A

Angela Byars

I am creating a form and one of my combo boxes has a table as the control
source. The table contains two fields: request type and description. I'd
like to display the description for the request type that is chosen but
can't quite figure out how. TIA - Ange
 
I am creating a form and one of my combo boxes has a table as the control
source. The table contains two fields: request type and description. I'd
like to display the description for the request type that is chosen but
can't quite figure out how. TIA - Ange
Click to expand...
First consider using a query for the Row Source of the combo box. You
have much better control over how and what is displayed.

Now if you have two columns in the rowsource make sure the combo box
is set to 2 columns. Since you want to see the second and not the
first set the Column Width to 0";1.5" - or whatever you need to
adequately display the second column.

- Jim
 
Back
Top