I am writing some transactions into a couple of Access tables using ADO and
wrapping the transactions with BeginTrans/CommitTrans, all recordsets and
connections are correctly closed when finished.
The sub is called from a command button on a form and after the
transactions
are committed I am trying to requery the forms recordset and using
recordsetclone to move the form to the newly added record.
The problem is that although the ADO code correctly adds the new record to
the table the form requery is unable to 'see' it, or even requerying a
listbox based on the table.
Is there an answer to this problem please?
