Button On A Sub Form (1 Viewer)

[Derrick T. Davidson]

Hi All,
I am new here and not an expert in code.
My Question, I have a sub form containing a sub form;

I have a sub form [frmSubTransactionBalance] which I have placed a button [btnStatDate]

When I click the button I want:
The txt box on [frmSubTransactionBalance] [trStatDate] to refer to the sub form [frmSubStatementLastDate] and the txt box [MaxOfStatDate] and insert the date in [MaxOfStatDate] on [frmSubStatementLastDate] into [trStatDate] on [frmSubTransactionBalance]

My first post I hope it is clear???

 

[arnelgp]

on you button click event:

private sub button_click()
Me![trStatDate] = Me![frmSubStatementLastDate].Form![MaxOfStatDate]
end sub

 

[Derrick T. Davidson]

You are the best thank you so much