Get value from first record in subform

[tylerg11]

With VBA I need to access my subform from the main form. I am trying to specifically retrive the value from the first record of the subform. The following doesn't always work.

Me![Subform].Form![Field]

If gives me a value, but it isn't always the first one in the subform. Any ideas as to some syntax I need to get that first value?

[June7]

I always give subform container control a name different from the object it holds, like ctrOrders.

Possible options (not all tested):

1. move to the first record of the subform, try:
DoCmd.GoToRecord Me.subformname, , acFirst

2. open RecordsetClone of the subform and read value from first record of the recordset, like:
Me.subformcontainername.Form.RecordsetClone!fieldn ame

3. a textbox in subform (in Continuous view) footer with expression like: First(fieldname) then textbox on main form refers to the textbox in subform footer
Me.subformcontainername.Form.textboxname

4. DLookup to get value from table, would need same filter criteria applied to the subform

[tylerg11]

I've tried

DoCmd.GoToRecord Me.subformname, , acFirst

But then how do I reference the actual value of that record?

[June7]

Set a variable or textbox.

strData = Me.subformcontainername.fieldname

or

Me.textboxname = Me.subformcontainername.fieldname

Use the actual names of your controls and forms.