I am trying to use a command button to execute a query for each line item that is returned in a continuous form. The query associated with the command button references a field in a line in the continuous form. The problem I am running into is that the code references the first record returned no matter what line of the continuous form I am trying to query off of.

Example, if there are 15 line items returning values for this field. When I push the button associated with items 2-15 it returns the value seen in field 1 everytime.

Am I trying to do the impossible, or is there a way to accomplish this task?

Thank you,
KellJW

I'm not quite sure what you mean by continuous form. It sounds like you are not enumerating through the values on the form. Can you be a little more specific?

Thearon