Command button and Recordset

[informer via AccessMonster.com]

I have a continuous form based on a query. I have two text fields that I
want to be able to update when the user clicks the Next command button. I
basically want to get the next PositionID and get the two text fields to
update. I was wondering if anyone can guide me through this?

 

[Pat Hartman]

Do you really want to update a record simply because someone viewed it?
If so, your best bet is to turn off the default navigation bar and add your
own buttons. That way, in the click event of the "next" button, you can
update the current record. This event isn't exposed with the standard
navigation bar.

If you only want to update the records that actually were changed, you would
add your code to the BeforeUpdate event of the form.