Hi I have a table called CSRNames with 2 Columns, 1 called CSRNames and 1 called TM. I then have a form which has 2 comboboxes, 1 for CSRNames column and 1 for the TM column. What I would like to do is for the TM combox box to auto populate based on the name chosen in the CSRName combox. I've tried the following, but it isn't working: Private Sub CSRName_Change() Dim varX As Variant varX = DLookup("[TM]", "CSRNames", "[CSRNames] = Me!CSRName.Value") Me!Team_Manager.Value = varX End Sub Any help appreciated. Thanks.