evaluate an unbound control value as it is being entered

[markjkubicki]

stumped

trying to check the value of an unbound control as it is being entered (vs. before / after update, lost focus...);
essentially as soon as the user starts to enter printing characters into the textbox

Private Sub txtTemplateName_Change(frm As Form)
    Dim blnIsNew As Boolean
    With frm
        blnIsNew = IsNull(DLookup("[TemplateID]", "tblLuminaireTemplates", "[LuminaireType]= '" & .cboLuminaireType & "' AND [TemplateName] = '" & Trim(.txtTemplateName) & "'"))
        If blnIsNew Then
                .cmdSaveTemplate.Enabled = True
        End If
     End With
End Sub

as always, with appreciation in advance,
m.

[CJ_London]

if you are using the change event you need to use the .text property

Trim(.txtTemplateName.text)

you are aware the change event fires every time a character is entered or deleted? so your dlookup will be working overtime