HI.
I have a Form with a Codes field and a Description field from my Codes table.
In my Form I want the Description field to auto populate when I enter in my Code field.
I DO NOT want my Code field to be a Combo Box.
I was told to enter this DLookup expression in the Code field After Update property.
Me.Description = DLookup("[Description]", "tblCodes", "Code = " & Me.Code)
When I do this I get an error message that says it cannot find tblCodes.
When I delete the tbl part, it will work, but it only populates description from the first record of the Codes table.
Any input would be greatly appreciated. Thanks.