Handling a Misspelled Name in a Form

[krenee]

Right now, I'm trying to design a form which allows the user to look up a name in a database. It's a QBF form that includes two unbound textboxes, one for the person's first name and one for the person's last name, and a button which runs a macro. That macro then opens a query which selects and displays any entries with that name.

The form works perfectly as it is right now, so there is no problem with its execution. However, my supervisor asked me to try to have it recall similar names in case the name entered is misspelled (e.g. if "Smuth" were entered as a last name, have the form call up any entries from the table or query with the last name "Smith"). Is it possible to do this in any way? Or is there a way to produce an error message that indicates similar names? This is not a necessary feature for the form, but it may make things easier for my supervisor.

Thank you!

(I should note that I am very much a beginner in the SQL Language. I was taught to build forms, queries, and tables from the Access design view, but I only got a brief overview of the actual code involved. However, if there is some code that would help in this situation, I will do my best to figure out how to use it!)

 

[Kryst51]

You could create a combo box instead of the text box and limit to list, so that it only uses available names, then you wouldn't have to worry about misspelling.