Check the name by using DLookup or a recordset to see if that name exists in
the table. Both methods are outlined in the help files. Post back if you
need more help.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads http://www.datastrat.com http://www.mvps.org/access
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.