Display description

[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

 

[Jim Allensworth]

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

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