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

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

Post by Kim » Sun, 24 Apr 2005 00:20:49


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