Reference to subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Neil said:
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?
Click to expand...

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