Runtime error 2450

Question

Hi all,

I have a form with a subform.

The main form is linked to a table with data. The subform is linked to a different table with attachments. The two tables are linked to each other with a field that holds the course number.

On the main form, the user selects a record to edit. I want the corresponding record in the subform to be retrieved, but I get a runtime error 2450, stating that Access cannot find the referenced form.

I am using code in the "AfterUpdate"procedure of the main form:

Me.RecordsetClone.FindFirst "[ScheduleID] = " & "'" & Me![Combo0] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
Me.RecordsetClone.FindFirst Forms!Frm_CourseScheduleDET_EDIT_SubForm.[Sch_ID] = Me![Combo0]
Me.Bookmark = Forms!Frm_CourseScheduleDET_EDIT_SubForme.RecordsetClone.Bookmark

I have tried other options as well, but keep getting the same error.

Any assistance will be appreciated.

Thanks

Deon

Answer 1

Me.RecordsetClone.FindFirst "[ScheduleID] = " & "'" & Me![Combo0] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
Me.RecordsetClone.FindFirst Forms!Frm_CourseScheduleDET_EDIT_SubForm.[Sch_ID] = Me![Combo0]
Me.Bookmark = Forms!Frm_CourseScheduleDET_EDIT_SubForme.RecordsetClone.Bookmark

Hi Deon,

"Me"  refers to the main form (I suppose, because of the Combo0), so you can't use it for the subform.

You can define a subform-form object

    Dim subx_form as Form

    Set subx_form = Me(<subformcontrolname>).Form

and from then on use subx_form instead of Me for the synchronization.

Imb.

Answer 2

Are the master-child links set up properly between your main form and subform?  In most cases, no additional code is needed for the subform to respond when the mainform record changes - it will automatically filter to records according to the linked field.  Have you tried just this?

Me.RecordsetClone.FindFirst "[ScheduleID] = " & "'" & Me![Combo0] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

Also, IF scheduleID is a numeric field, omit the single quotes:

Me.RecordsetClone.FindFirst "[ScheduleID] = " & Me![Combo0] 

---

Miriam Bizup Access MVP

Answer 3

Hi Deon SA,

You had mentioned that,"On the main form, the user selects a record to edit. I want the corresponding record in the subform to be retrieved"

Do you mean something like below?

If yes then you can use code like below.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!Child11.Form.Filter = "[course _number]= " & Me.coursecombo
Me!Child11.Form.FilterOn = True
Me!Child11.Form.Requery
End Sub

Just for a demo i use Form_BeforeUpdate event, you use Form_AfterUpdate event.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Hi all,

Thanks for the responses and advise.

The problem was that I never linked the Master - Child links. It now works.

Much appreciated.

Deon

Answer 5

The problem was that I never linked the Master - Child links.

Hi Deon,

Did you mark the correct answer?

---

Miriam Bizup Access MVP