Code no longer working now that form is subform

[Degs29]

I created a form with the following code:



Private Sub Item_AfterUpdate()
Me.Description = DLookup("[Description]", "RMList", "RMList.[Item] = Forms![RMS]![Item]")
End Sub

This worked fine. Yes, I understand it doesn't follow normalization rules (I'm going to fix that shortly). The user would select an item from the list, and its description would be autofilled in the next field (I'm going to change that so it merely is displayed).

However, now I've implemented that form as a subform for another form. The code no longer works and I'm getting "runtime error 2001" and I was interested in knowing why.

[pbaldy]

The syntax changes when it's a subform:

Forms Refer to Form and Subform properties and controls

but you may find this cleaner:

BaldyWeb - Autofill