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!
