N
Nigel Lawton
When I add records to a recordset using code .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 but these do not fix the problem. Sometimes two
manual remove filter/dort commands are needed.
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 but these do not fix the problem. Sometimes two
manual remove filter/dort commands are needed.