Reference to subform?

[Guest]

I have the following if statement:

If Forms("Water Plans").NewRecord Then
Me.Project_Number = Forms("Plan Status").ProjectNumber
Me.Project_Name = Forms("Plan Status").ProjectName
Else
Exit Sub
End If

I'd like to include a line similar to the Project Number and Name lines
where the control is set to the data from the controls of "Plan Status". The
problem is, the data I want is from a subform on the "Plan Status" form. How
can this be done?

 

[Marshall Barton]

I have the following if statement:

If Forms("Water Plans").NewRecord Then
Me.Project_Number = Forms("Plan Status").ProjectNumber
Me.Project_Name = Forms("Plan Status").ProjectName
Else
Exit Sub
End If

I'd like to include a line similar to the Project Number and Name lines
where the control is set to the data from the controls of "Plan Status". The
problem is, the data I want is from a subform on the "Plan Status" form. How
can this be done?

Me.textbox = Forms("Plan Status").subform.Form.sometextbox

 

[Guest]

Thank you, that worked perfectly.