TLBroadbent, Are You Around, I need help with ResyncCommand

[jbroyles]

In my previous post, I thought my select statement was causing the error:

"The data was added or updated in the database, but the data won’t be displayed because it doesn’t satisfy the criteria in the underlying record source"

I found that not to be the case as any trigger using Insert caused the same problem.

I moved on to thinking it was ResyncCommand and I set it to the same SQL statement as the RecordSource for the DAP. I am using a server filter to pass the ProspectID field value to the next DAP. When the recordset resynch's it displayes a value in the prospectsID field that does not exist. ProspectID is an autonumber field and the primary key in the recordset. Any ideas?

Thanks in advance