Repost-Autokeyes error

[Mattias]

Hi

I have Access2002 and to be able to use the F12 on the keybord to go next
record in subform..I am using Autokeys.
Everything works fine pressing F12 and the subforms goes to next record,
except when any changes has been made in the subform...I have both Before
update and After Update starts a few update queries.
The error message I get is: "You cannot go to the specified record. You may
be at the end of a recordset."

Any help with this is most appreciated

Mattias

 

[Steve Schapel]

Mattias,

Is the subform in single view? Your F12 Autokeys may jus be replicating
what is aleady directly available via the PageDown key.

In any case, I would expect the problem is caused by your Before Update
event. Without knowing more details, it is hard to know what to
suggest, but I think you will need to find a way to save the record,
including the Before Update data processing, before you try to move to a
new record.

 

[Mattias]

Hi

Thanks for your suggestion..it worked.
It was single view but I did not have any save record..now it works fine!

Mattias