Hi,

I have the following code:

Set fs = Application.FileSearch
With fs
.LookIn = "\\Desktop_Pub\Graphic Images\Head Shots"
.FileName = "*" & myid & ".jpg"

If Len(.FileName) > 0 Then
Me!Headshot = (I want this to be the exact file name)
End If
End With

How can I set Me!Headshot to the exact file name when the search is successful? .FileName uses a wildcard. I don't know what the code should be.

Thanks!