Hi

I am reasonably familiar with the code to loop through dataset records and assign the values to variables, but I am currently stumped on something I am trying to do.
I have a form with various text boxes with points values in them and calculates a total of these points into another text box. I want to loop through the fields of a table and find a value that matches the total on the form, I then want to be able to display the result in another text box on the form.As an example imagine the table as follows
Field -- A--- B
Value -15- ABC
Value -25- DEF
Value -40- GHI

If the code loops through column A and if it finds the value on the form matches 25 then I want the value DEF to be able to be displayed on the form.
I thought that the code could run from the "After Update" event on a text box or combo box.
Thank you in advance, hoping you can understand my logic
Best regards

If you don't care if more than one value equals the total then you can use the DLookUp() function. After the total is calculated you can use it to find a record in the table where the value is equal to the total in question and pull the other data. For example:

Me.txtDesiredValue = DLookUp("[B]", "MyTable", "[A] = " & Me.txtTotal)

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division