Remove a macro (I think?)

[bellemmar]

How do I change the parameters of the search box so that it only searches the Last Name field?

I think this is a macro question but I'm not sure. I deleted a bunch of fields but when you type a name in the search box, dialogue boxes still pop up for the fields I deleted saying "Enter Parameter Value".

 

[Chad-M]

Try this. It will find where the space is between the names and then extract only the last part.
sFullName is the variable for the full name.


Dim iSpacePos As Integer
Dim sFullName As String
SepName As String

iSpacePos = InStr(sFullName, " ")
SepName = Mid$(sFullName, iSpacePos + 1, Len(sFullName))