Data Entry Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Sql 2000 and Access 2003.

I have a work order form with a check box. When the work order is completed
the user checks the box and moves to the next work order.

The problem I'm having is when the user checks the box the following error
appears:

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

I'm getting the error because the query check box criteria is '0'.

What do I need to do to keep from getting this error?

Thanks for the help,

Paul
 
You are using a 'dynaset'? a dynaset (MS SQL Server meaning, not DAO
meaning) re-evaluate the WHERE clause after a modification and if the record
does not pass the criteria, anymore, after the update, it is dynamically
removed from the recordset! Try using a keyset: on opening the recordset,
the 'keys' (pk, or bookmarks) of the records that belong to the set, because
of the WHERE clause or otherwise, is kept and from there, the WHERE clause
is not re-evaluated anymore. Sure, both types of recordsets allow you to
append new records, but a dynaset won't display one that does not fit the
WHERE clause... As example, if you have WHERE Qty>10 and you update the
Qty, from 12 to 9, in a dynaset, that record will be updated and immediately
REMOVED from your recordset, leaving you in the impossibility to 'undo' the
modification, through the same recordset.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top