Data from Previous Record in Tabular Subform

[skwilliams]

I have a form (frmMain) with a tabular subform (frmSub). The forms are related by a field (txtName) on the main form and (fkName) on the subform.
The subform contains a field (ErrOrd). I need to pull the ErrOrd from the last record input on the subform to use on the main form.

Any help is greatly appreciated.

 

[mohammadagul]

1. put a text box
2. control source : =[SubformName].Form![FieldName]

 

[skwilliams]

This is a tabular subform. By setting the field's control source on the main form to the subform field, it wouldn't know which record to pull from.