[Originally posted by Rich Meinert]

I need to have a user fill in a text box on a form with an ID for a certain farm field , then I need the program to retrieve the value
in the text box , use it to look up the most recent soil test result available from a data table so I can use the soil test data in a calculation to
determine the fertilizer needed for the crop field.

I can get the textbox.text input to retrieve the field but how do I go about using the value to look up the soil test info?