Access 2010: ODBC Oracle Table with acNewRec - getting the triggered Primary Key
Posted on 2013-10-28
I have an ODBC linked table with a form that has an Add button.
The Table has an Oracle Trigger that generates a unique ID from a sequence IN ORACLE.
This is triggered before the update on the Oracle side.
When the ADD button is clicked, I issue a
"DoCmd.GoToRecord , , acNewRec"
I set a few hidden txt boxes that are bound to the ODBC table.
I then look for the Primary key. It is still null.
This means that the Sequence is not being triggered just yet.
How do I get the record "forced" into Oracle and still allow my user to input values into the new record?
Or any other ideas?