Access/SQL: record saves when I run macro or code

[DocNice]

I am running an Access interface to a SQL server. When I run a macro or code, the form saves the current record and moves to a new line.

Any idea why this is happening or how to work around it?

 

[IgorB]

I created your problem manually and can confirm that if you go in database to menu "Tools--Options---Keyboard", you probably have setting "Next record". You better of to change it to "Next field".
It works perfect for me.

Good luck.
Igor.

 

[DocNice]

IgorB,
Thanks for the suggestion. I found some other things in there that help me, but it still doesn't fix this problem. I think it's to do with SQL, because it seems to work fine with Access tables.

 

[DocNice]

You're right it's not SQL. I thought it was, because all of this was working right before I moved the tables to SQL, and with the autonumber being assigned at the end, I thought it was another change like that. In the interests of being thorough, I have done quite a bit of troubleshooting and have ruled that out, as well as running macros, though I still haven't found the source yet.

Thanks for your help. I'm sure I"ll get it.