Access ADP / SQL Server Trigger

  • Thread starter Thread starter Gern Blandston
  • Start date Start date
G

Gern Blandston

Sorry for the cross-post. I posted this in the form/programming group
but didn't see the ADP group.

I'm working on an Access Data project against a SQL Server
2000 database. I have a form that contains a subform. The
subform has a View against a single table ("tblFactories")
for a Control Source.

tblFactories has an insert trigger
that writes out updated fields to an audit table
("tblAudit"). tblFactories has a primary key
called "FactoryID" which is an Identity Field.


When I insert a new record into the subform, I get the
following error:

"The Data was added to the database but the data won't be
displayed in the form because it doesn't satisfy the
criteria in the underlying record source"

I think I'm supposed to use the Resynch property, but I'm
not sure what it should look like. Any help would be
apprciated.
 
Steve Jorgensen said:
ADO will be confused, and look for the newly entered record using the identity
value of the record added to the table in the trigger, not the identity value of
the record ADO was trying to add.
Click to expand...



Yeah, that's probably it. Thanks, Steve.
 
Back
Top