I have a main form with a subform. In the main form there is a command button (paste from Clipboard) which causes data which has been copied to the clipboard from Excel to be paste-appended into the subform using the following code:
Private Sub cmdPaste_Click()
On Error GoTo proc_err
Me.sfmGenFeed.Form.AppendMe 'this just runs DoCmd.RunCommand acCmdPasteAppend
RecalcTotals 'A procedure to calculate aggregates
Call fncErrorLog("Form", Me.Name, "cmdPaste_Click", Err.Description)
This works fine on the first click. However the problem occurs on subsequent clicks. The behaviour is as follows: although more appended data appears in the subform, inspection of the underlying table indicates that although the first batch of appended records are present, subsequent appends do not in fact append any more data into the table. Furthermore the aggregate calculations do not change and there is no standard confirmatation dialogue box.
Any ideas anyone ?