<div>
<div class="content wysiwyg-content">
I need to pass the Second column value from a value list within a table. for use in a query or to display the correct value on a form.<br />
<br />
tablename = tblTC<br />
FieldName = collectedby<br />
Field Value = <br />
Code &nbsp; &nbsp; &nbsp;Name<br />
EC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Expert Collect<br />
HC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Helper Collect<br />
DIV &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Divided Option<br />
<br />
The results to be displayed in the query should read &quot;Expert Collect&quot; or Helper Collect or Divided Option and not the Code value.<br />
<br />
what do I need to do to display the correct value on the form or within the underlying data source?<br />
<br />
K
</div>
</div>


I need to pass the Second column value from a value list within a table. for use in a query or to display the correct value on a form.

tablename = tblTC
FieldName = collectedby
Field Value = 
Code      Name
EC           Expert Collect
HC           Helper Collect
DIV          Divided Option

The results to be displayed in the query should read "Expert Collect" or Helper Collect or Divided Option and not the Code value.

what do I need to do to display the correct value on the form or within the underlying data source?

K

Retrieve the second column value in a Value list in a table.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.