Looking to perform this task:

from a database load two field values in an array like

rst!Field1
rst!Field2

Question 1: How to a load it into an array?

Question 2: Based of user typing in response, how can I look up the value from the user in the array(Field 1) and return contents of Field 2 (kinda of a vlookup table in VB).

Please help !!!