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 =
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?