Populate Text Box from table based on combobox value

Hi there



I am new to the world of forms in Access and would like some assisatance with a problem I am having.



I am trying to populate the text boxes in a form with data from a table based on the selection a user has made in a combobox. I am trying to do this through a DLOOKUP in the text boxes Control Source using the following:

Code:

---

=DLookUp("[upMobile]","tblRepName","[tblRepName].[repContactMobile] = " & Str([upRepName].[Text]))

---

When I input this into the control source I am seeing a

Quote:

Invalid Control Property: Control Source Circular Reference

error.



This is showing as

Quote:

#Type!

in the form when viewing the data.



I am getting very frustrated and would appreciate any help!

Populate Text Box from table based on combobox value