i have a DB and a form...
in the form, when you enter a word and hit get details... the program will get the information it needs e.g you type in a fruit. the form collects the data:
--> Colour
--> size
--> calories etc.
from the database. The program then edits teh text in the text boxes to reflect teh data it has just received.

That's teh idea of what i need the program to do, what would the code be to collect the required information and disply it in the text boxes?