Look up Name in a Table

[Novice1]

Help please. I have a form. When I open the form I want to check a name on a separate query. If the name exists I want to show a msgbox. I'm having a problem coding the DLookup. Any help would be appreciated.

 

[Scooterbug]

Syntax for dlookup:

Dlookup("[FieldYouWantToReturn]","TableOrQueryName","[CriteriaFieldName]=Value)

 

[boblarson]

I would suggest using a DCount instead of the DLookup. Check to see if the DCount is > 0 (this way you don't have to deal with nulls using the NZ function with the DLookup).

 

[ajetrumpet]

If the name exists I want to show a msgbox.

i agree with Bob. use dcount. lookups are slow as heck and you'll be evaluating nulls instead of counts