Grabbing data from Main form to put in Sub form

[Rusty]

Hey guys,

Can anyone help with this problem? I have main form with basic data like "date" and "data entered by" and a subform with more detailed stuff.

What I want to do is have the date field in the subform grab the value form the date field in the main form.

I've put the code in the AfterUpdate event of the first field that needs to be filled in on the subform. It looks wrong and does not work. Any ideas?

The main form is called "frmCardiology_MAIN" and the field is called 'cboMonthOf'

The sub form is called "frmCardiology_SUB" and the field I need the value to go into is called 'MonthOf'.

Private Sub Trial_Name_AfterUpdate()
Me.MonthOf.Value = frmCardiology_MAIN!cboMonthOf.Value

Cheers,

Rusty

 

[batman1056]

can you not create a text box with
Forms![frmCardiology_MAIN]!['cboMonthOf'] in the subform