Another question (are you tired of me yet?)

I have successfully implemented the following code in order to check the address field to make sure it isn't a duplicate of a record that has already been entered (only one form in my database):

var DupAddress as string
DupAddress = @XLookup(@Filename, address0, "address0", "address0")
if DupAddress <> "" then
@Msgbox("Panic!","You may have already entered this address!","Look it up now to double check...")

I am now looking to develop this code a little to deal with possible discrepencies with the endings of addresses, ie, if the user enters "123 Forest Ave." she will be notified of the existence of "123 Forest Avenue", etc.

If I were to take a certain number of the first characters of the address, could I use @XLookup or a similar command from the "X" family to do something to the equivalent of the search function "123 Fore.."?  Which command should I start with?  How much would this lag the system?

Thanks so much...

What am I doing wrong?:

(variables declared)

alteredAddress = @Left(address0, 10)

dupAddress = @XLookup(@Filename, "alteredAddress..", "address0", "address0")
if dupAddress <> "" then
@Msgbox("Panic!","You may have already entered this address!","Look it up now to double check...")

Thanks, works great!

Another question: is there a way to look up and match more than one field at a time using XLookup?  The application of this would be if an address starts with "P.O. Box", I would want to warn the user only if there is a matching address and Zip code, because otherwise matching P.O. Boxes are too common and not worth the user's time.

If I was to try to do something like this:

dupAddress = @XLookup(@Filename, address0, "address0", "address0")
dupCity = @XLookup(@Filename, Zip0, "Zip0", "Zip0")
if dupAddress <> "" and dupCity <> ""
then...

XLookup would look up matching fields but not neccessarily in the same form.  Can I get them to sync and find if there are any matching fields on the same form?

Thanks for the idea it turned out great!