Joe- Well, you already have the query - the SQL you opened with OpenRecordset. You could open a dialog form that has a list box on it that uses that SQl as the Row Source for a list box. You need to open the form WindowMode:=acDialog to halt this code until the window closes. Code in the dialog form could open another form to review the selected record and possibly set a Public variable to tell your BeforeUpdate code whether to cancel the update or not.
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] On Behalf Of eliotchs Sent: Thursday, December 15, 2005 3:59 PM To: [email protected] Subject: [ms_access] ? on Using John V's Soundex ?? 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 Links ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/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/
