Hi,
I just upgraded my access database to SQL server backend. I have manually redefine primary keys and indexes in SQL server that matches the table structure in Acess. Now I am having problems with the primary key been autoincremented instantly.
In one of forms I link the primary key - ID number to another form through a button click. Previously with everything in Access, the automnumber increment instantly when a new record is added. Now with the data in SQL server, the ID number only gets incremented after the current cursor moves focus to another record. So when a user wants to open the other form, I get an error saying the ID is null because the current cursor is still in the new record.
Is there a way get the new ID number incremented without using me.refresh or me.requery?
thanks.
galantis
I just upgraded my access database to SQL server backend. I have manually redefine primary keys and indexes in SQL server that matches the table structure in Acess. Now I am having problems with the primary key been autoincremented instantly.
In one of forms I link the primary key - ID number to another form through a button click. Previously with everything in Access, the automnumber increment instantly when a new record is added. Now with the data in SQL server, the ID number only gets incremented after the current cursor moves focus to another record. So when a user wants to open the other form, I get an error saying the ID is null because the current cursor is still in the new record.
Is there a way get the new ID number incremented without using me.refresh or me.requery?
thanks.
galantis
