Access/SQL: record saves when I run macro or code (1 Viewer)

[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.

 

[Pat Hartman]

When I run a macro or code, the form saves the current record and moves to a new line.

What code are you running? Code that requeries the recordset for example, will automatically save the current record. In an .mdb there is no difference in when a record is saved when the be is SQL server rather than Jet. The only difference is when the autonumber is assigned. With Jet, you see the assigned autonumber as soon as you enter data into any field. With a RDBMS be, you won't see the assigned autonumber until the record is actually committed (saved).

 

[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.