G
Guest
Access2002
I am using the code below to store the value from a table in a text box
based on the results from a previous combo box.
The code below when used in a Form works fine, but when I try it in a
subform, it won't work.
Is there a problem with using Dlookup in a subform?
Private Sub varDutyID_AfterUpdate()
Me.TextDuty = DLookup("[LookupDuty]", "[Lookup1020Duty]",
"[LookupDutyID]=[Forms]![1000Model]![varDutyID]")
End Sub
I am using the code below to store the value from a table in a text box
based on the results from a previous combo box.
The code below when used in a Form works fine, but when I try it in a
subform, it won't work.
Is there a problem with using Dlookup in a subform?
Private Sub varDutyID_AfterUpdate()
Me.TextDuty = DLookup("[LookupDuty]", "[Lookup1020Duty]",
"[LookupDutyID]=[Forms]![1000Model]![varDutyID]")
End Sub