I
ILoveAccess via AccessMonster.com
Hello!
I have a form called "frmLeads" with two fields "FirstName" "LastName".
I type in FirstName: Jane LastName: Doe
If there is someone else in the database with the FirstName, Jane, and
LastName, Doe, then I want it to do the following:
1.) say, "There is another record(s)in the database that contain the same
First and Last Name. Would you like to veiw the other record(s)?"
2.) If I choose yes, then filter those records.
If I choose no, then ignore and let me continue entering the record.
Is there a way to do this?
Thanks!
I have a form called "frmLeads" with two fields "FirstName" "LastName".
I type in FirstName: Jane LastName: Doe
If there is someone else in the database with the FirstName, Jane, and
LastName, Doe, then I want it to do the following:
1.) say, "There is another record(s)in the database that contain the same
First and Last Name. Would you like to veiw the other record(s)?"
2.) If I choose yes, then filter those records.
If I choose no, then ignore and let me continue entering the record.
Is there a way to do this?
Thanks!