Set the DLookup in the text box VBA code under Got Focus [Event Procedure]. This way when you click the combo box it executes the code. In addition, it might work better to program out everything in there rather than using the DLookup. Issue with setting it in the Property Sheet sometimes. If that does not update your table then program in an AfterUpdate or LostFocus [Event Procedure] for the same text box with a If Me.Dirty Then Me.Dirty = False.
Example programming out DLookup:
Code:
Private Sub txtPoints_GotFocus()
On Error Resume Next
Dim strSQL As String
strSQL = "SELECT Points FROM SalesCalls WHERE CallType = '" & Me!cbxCallType & "' "
CurrentDb.OpenRecordset strSQL
Me!txtPoints.RowSource = strSQL
Me!txtPoints.Requery
End Sub
Code:
Private Sub txtPoints_AfterUpdate()
On Error Resume Next
If Me.Dirty Then
Me.Dirty = False
End If
End Sub
or
Private Sub txtPoints_LostFocus()
On Error Resume Next
If Me.Dirty Then
Me.Dirty = False
End If
End Sub
Just change the red stuff to whatever the field name is on your form. Once you select the text box you can find the field name as the form sees it under Property Sheet > Other > Name
Something else is to ensure the [Event Procedure] shows under Property Sheet > Event for which ever ones you program in VBA.
If that does not work then a screen shot would help. Just search "Snipping Tool" on Windows start menu if you are unfamiliar.