Update record - returns to the first record in the record set

K

Kim

Hi,
I have a form for participants in a class.
on the participant form there is a current date for the class - and a drop
down of the dates offered for the class.
I have a buttne when clicked will execute the following update query

Update OrderDetail set classDatesID = 34 Where orderDetailID=10035


problem is orderDetailID is ALWAYS the orderDetailID for the first
participant no matter which participant record I am on when executing the
query.

any idea what might be wrong?


thanks,
Kim
 
Top