Soundex is bombing when you try to pass it a Null last name. Change the
code to:
Set rst = CurrentDb.OpenRecordset("SELECT LastName, FirstName FROM " & _
"client WHERE Soundex(NZ([LastName], ' ')) = '" & _
Soundex(Me.LastName) & "'")
You also have a problem that the form always thinks it's "dirty", so you get
an error on the required SSN number when you try to clear and close the
form.
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 13, 2005 9:13 AM
To: [email protected]
Subject: [ms_access] New file uploaded to ms_access
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the ms_access
group.
File : /clientdb.ZIP
Uploaded by : eliotchs <[EMAIL PROTECTED]>
Description : Client Db for John V to check
You can access this file at the URL:
http://groups.yahoo.com/group/ms_access/files/clientdb.ZIP
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/help/us/groups/files
Regards,
eliotchs <[EMAIL PROTECTED]>
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
