Checking for valid return of DLookUp

[WAVP375]

I have a valid DLookUp text box that returns the proper data. I am attempting to determine if the DLookUp has been executed or if the returned value is blank.


I have used the If IsNull, The IIf(IsNull0, and the If Len(Me.Text & vbNullString) = 0 possibilities and all generate an error of some sort.
Any other possibilities?

Thanks

[Gicu]

Have you tried =IIF(isnull(dlookup("","","")),"N/A",dlookup("","","")) as the control source of the text box?

Cheers,
Vlad

[davegri]

Remove the dlookup from the data source property and put it in the form_current event:

Form_current
    me.mytext = nz(dlookup(......),"")
    if len(me.mytext & vbnullstring) = 0 then
        me.mytext = "Not Found"
    endif
end sub

[accesstos]

Maybe I didn't understand the question but, why not =nz(dlookup(......),"Not Found!") in control-source of textbox?
Or with =dlookup(......) in control-source and with @;[Red]"Not Found!" format?

[WAVP375]

A little more explaination. The dlookup is used to visually verify that a valid badge number has been entered into another texbox which is used in the dlookup.
=DLookUp("[FullName]","[TblVolunteers]","[Badge]="&[Forms]![FrmCompletionDate]![Badge]
Will either of the suggestions work in this situation. Meanwhile I will test them.

Thanks

[davegri]

The algorithm for this sounds all wrong. I assume you want to validate whether a badge exists for the volunteer. What if it does exist but frmCompletionDate has the wrong badge number entered?
A more rigorous check would be NZ(Dlookup("[Badge]","TblVolunteers","VolunteerID=" & me.VolunteerID),"")
You would need to adjust the VolunteerID field name for your circumstances.

[WAVP375]

There is no way programmatically to check if the proper badge has been entered, that's why I want to display the name that is associated with the badge. The visual check determines if it is the correct number.
I am more looking for ,Was a badge number entered and is there a name or did it return a blank. Either of those conditions I can deal with. Thanks, I will give some of these suggestions a shot.
I will be back later

[WAVP375]

Thanks to all of You. Vlad has solved my problem..