Referecing data from subform in datasheet view

Hello all,

First time posting but havent found my answer anywhere on the net so I figured I would give this a shot.

I have a form that contains customer general details and I have a subform that is in datasheet view with order details. I have some fields outside of the subform that i will link with the subform data and add to a table. My problem comes in that I can not figure out how to access cells in this subform. I have tried things like:

forms![main customer form]![order subform]!cells(1,1)

and a bunch of variations with this and the cellset function and just can't get anything to work out. I hope someone has worked through a similar issue. Thanks for your help.

You have to reference the actual field name, unless you use a recordset clone in which event you can use the field position in a recordsetclone.