I've got several tables in Oracle that I'm linking to.
When the user chooses to insert a record in a few tables that have an AutoIncrement field as the primary key (a trigger creates the value) Access displays #Deleted for all the fields on the form - and I've found out why that happens from MS:
In all but one case I've been able to get around this by capturing the New value for the primary key in the AfterInsert event, and then use that to requery/reposition to the just-inserted record.
I can code additional lookup fields to find the record I'm looking for, but I'm wondering why SOMETIMES the key value doesn't come back in the AfterInsert event - has anyone else had this problem? or better yet - found a solution?
Thanks
When the user chooses to insert a record in a few tables that have an AutoIncrement field as the primary key (a trigger creates the value) Access displays #Deleted for all the fields on the form - and I've found out why that happens from MS:
In all but one case I've been able to get around this by capturing the New value for the primary key in the AfterInsert event, and then use that to requery/reposition to the just-inserted record.
I can code additional lookup fields to find the record I'm looking for, but I'm wondering why SOMETIMES the key value doesn't come back in the AfterInsert event - has anyone else had this problem? or better yet - found a solution?
Thanks
