Search results

I haven't been able to figure out the code to require entry (for a new record) in a field on a subform - anyone can help with this? The situation is a contacts database, and each new contact should have a (or multiple) Person Roles entered as well, which is their relationship to the organization.

So now, I'm using the code below to prevent duplicate name entry and it is working great - EXCEPT when I enter a first or last name which contains a ' (ie, O'Tool, O'Malley, O'Hern)...anyone got any ideas for me on how to make this not happen? The error I get is: Run Time error '3075' Syntax...

Weird little error So now, I'm using this code and it is working great - EXCEPT when I enter a first or last name which contains a ' (ie, O'Tool, O'Malley, O'Hern)...anyone got any ideas for me on how to make this not happen? Private Sub Last_Name_AfterUpdate() 'Check for duplicate first and...

perfect! hi RV, thanks - the second one worked great!! i'll note the difference between using DCount and DLookup. (the first bit of code still gave me that same error message "Run time '2001' - You canceled the previous operation.") lkwander

Have read through all the threads related to this topic and can't find anything to help. Just want a message box to pop up after entry of first and last names in a form if the string already exists in the database. DLookup works wonderfully for validating on one field, but adding the second...