 <p>You could use DLookup for this - much simpler:</p> <pre><code>Private Sub cmbConsultant_Change() Me!txtHourlyRate.Value = DLookup("defaultFee", "tblConsultants", "ID = '" &amp; Me!cmbConsultant.Value &amp; "'") End Sub </code></pre> <p>However, most likely your ID is numeric, thus:</p> <pre><code>Private Sub cmbConsultant_Change() Me!txtHourlyRate.Value = DLookup("defaultFee", "tblConsultants", "ID = " &amp; Me!cmbConsultant.Value &amp; "") End Sub </code></pre>