Hi,
This question is really to John V. since this is his code..
John,
after going thru the code, and it works great, I've been trying to
figure out a way to change the msgbox to a listbox, is this possible?
Here is my reasoning, I changed:
Set rst = CurrentDb.OpenRecordset("SELECT LastName, FirstName, ssn,
location,ID FROM " & _
"clientlookup WHERE Soundex(NZ([LastName], ' ')) = '" & _
Soundex(Me.LastName) & "'")
to use query clientlookup,
if the listbox would popup, then a person could choose a client from
the list and another form would open verifing the client and/or
changing the clients location .
I think in my case the listbox would work out better.
If a listbox is not possible, is there a way to pass the soundex to a
query showing the names?
Thanks
Joe
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
