Updating one box from another

[Sumo]

Really new to Access so appreciate any help here.


I am trying to update one text box on a form based on the input into another. In the first text box I input manually from a combo box my colleagues Corp ID, in the next I want this to automatically pull through the persons name. I have a query written with the name in the column next to the Corp ID but I can't figure out how to pull it through. Tried dlookups on event change but can't get the coding right.
Any help?

[Missinglinq]

If CorpID is defined as Text

Me.PersonName = DLookup("PersonName", "TableOrQueryName", "CorpID = '" & Me.CorpID & "'")

If CorpID is defined as a Number

Me.PersonName = DLookup("PersonName", "TableOrQueryName", "CorpID = " & Me.CorpID)

Linq ;0)>

Place it in the AfterUpdate event of the CorpID Combobox and replace all names with your actual names.

Linq ;0)>