Syntax to reference subform from other subform on split-form in 2007

J

JC

Hi All,

I have a form in Split form mode.

On the form section I have two subforms. The first subform has a list of
courses that student is taking - FrmSubCourseRef. the second subform
shows details of the course - FrmSubCourseDetails.

OnDoubleclick on the CourseReference Field in FrmSubCourseRef should
filter the second subform FrmSubCourseDetails showing the details for
that course.

The problem is that the syntax for referencing the second form does not
work in the split-form.

Me.Parent.Form![FrmSubCourseDetails].Form.Filter = "CourseRef= " &
Me.CourseRef
Me.Parent.Form![FrmSubCourseDetails].Form.FilterOn = True

The error message I get is "Error during Execution '-2146500594
(800f000e)': The method 'Parent' from the object '_Form_FrmSubCourseRef'
failed."

If I use normal forms, no problem with the syntax. I'm experimenting
with the split-form option in 2007 and this reference won't work.

Any ideas why?

Thanks,

Jeff C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to find the name of the present subform 7
set focus to control on subform 0
Referencing Subform Controls/Properties 2007 3
Trying to Open subform on click event to current record from main form 2
Selecting current record in subform after removing filter 1
ApplyFilter event on a subform 1
Access 2007 "no current record" on split form 1
Reference Previous control on subform from a Main form control 3

Top