Recordsetclone

[Tallbloke]

I have the following bit of VBA which works like a charm :

With CallNotes.Form.RecordsetClone
         .AddNew
              !CustomerRef = Me!CustomerRef
              !Who = Forms.markswitchboard!Text52
              !Date = Now()
              !Notes = "Final Deposit Due on" & " " & FinalDepositDueDate
              !DiaryDate = FinalDepositDueDate + 1
         .Update
End With

However, if I try to use this code on a different tab control it just doesn't work.

I get Runtime Error 424 object required.

I guess I am asking how to reference one subform from another?

 

[Tallbloke]

Ah...got it! Posting here always helps

With Forms!Customer!Payments.Form.RecordsetClone

End With

 

[Galaxiom]

Another way to refer to another subform on the same main form:

Me.Parent.othersubformcontrol etc.

This has the advantage of working wherever the subforms are located instead of relying on the reference via the Forms Collection.