FindRecord ""

[rockman]

Is there a way to use FindRecord to find the first occurance of a particular field with a zero-length string?

The following code generates an error (requesting that criteria be supplied for the FindRecord method)...

fldLastName.SetFocus
DoCmd.FindRecord ""

Any help would be appreciated,
Jeff

 

[cpod]

Try this:

Me.Recordset.FindFirst "fldLastName Is Null"

 

[rockman]

Thanks for your response cpod.

Works like a charm!