Label text from dynamic array

[Tom]

Hello,
What I am trying to do is load an array from two columns in a table.
What I want to use this for is to control the text of a Label.

Table to be loaded in array
CODE LABELTEXT
A text1
B text2
C text3
D text4

I want to create a report that will pull the data from a table with one of
the columns corresponding with the code from the array.
I will place a text box linked to the code and then code it If txtCode =
"linked to code from array" THEN lblText.caption = "linked to code from
array

I think this can be done but I have not been able to get it to work yet.
I hope this is almost clear.
Any help with this would be much appreciated.

 

[Duane Hookom]

I'm not sure why you need to use an array. Access is a database with records
in tables and queries. Could you back up and tell as what you have and what
you want to accomplish.