Invalid reference to the parent property

[Access_Novice]

I have a combo box which is set up through the wizard to jump to a record based on the name I select. It is unbound. I have a blank field called street. I am trying to do a DLOOKUP to populate the street field.



Look at the street1 field of the Parents table where the parentID is equal to the field called parent on the form which holds a parent ID number.

Private Sub Combo63_AfterUpdate()
    Street = DLookup("street1", "Parents", "parentID=" & parent)
End Sub

What is wrong with my code?

[pbaldy]

This would be more efficient if it fits your setup:

http://www.baldyweb.com/Autofill.htm

if not, you're probably running into a reserved word issue, as Parent can refer to the parent form of a subform. You might try

Me.[parent]