N
NigelLawton
When I add records to a recordset using code (OpenRecordset - dbOpenDynaset, .
addnew & .update) I find that an immediate requery does not always show the
new record in the form I use to display the data. The form is linked to a
query which orders the records but does not restrict the selection. A delay
with DoEvents sometimes works but not always. How can I reliably get the new
record to be displayed without the need for a manual 'remove filter/sort'. I
tried putting in Requery, ShowAllRecords and refresh after the .update (and
close recordset and db) with and without delays up to a couple of seconds but
these do not fix the problem. Sometimes two manual remove filter/sort
commands are needed.
addnew & .update) I find that an immediate requery does not always show the
new record in the form I use to display the data. The form is linked to a
query which orders the records but does not restrict the selection. A delay
with DoEvents sometimes works but not always. How can I reliably get the new
record to be displayed without the need for a manual 'remove filter/sort'. I
tried putting in Requery, ShowAllRecords and refresh after the .update (and
close recordset and db) with and without delays up to a couple of seconds but
these do not fix the problem. Sometimes two manual remove filter/sort
commands are needed.