Dlookup with ComboBox and Text criteria

[reggiete]

Hello i am having issues with a dlookup formula. The dlookup has 2 criteria which is a combo-box and text. Please see the forumla below

Original code without combobox
Nz(DLookUp("CountOfStatus","Analyst Summary","[Remediator] = 'John Doe' And [Status] = 'Aged'"),0)
Name of combobox on form UserQueueSelected

So i would want to replace the criteria section for [remediator] to the combox, instead of typing the name of the person. the combo box will be text.

 

[Ranman256]

Nz(DLookUp("CountOfStatus","Analyst Summary","[Remediator] = '" & cboBoxName & "' And [Status] = 'Aged'"),0)