Check if record exists based off one field
Advanced Beginner
Windows 7 64bit 
Access 2007
I have two tables, one to track basic information (CompanyInfo) and one to track personal information (PersonalInfo). On the form is a field for an SSN. I am trying to set it up so that after entering in the SSN, it checks PersonalInfo to see if it already exists. If it does, drive on; if not, open up a form (NewAccount) to enter new information. Thank you in advance for the help.
VIP
Windows XP Access 2010 32bit
You could use a combobox that has a RowSource of existing SSNs from the PersonalInfo table. If SSN not in list, then open form to enter new record. Explore the NotInList event of comobox.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows 7 64bit Access 2007
Ok, I set up a combobox with all of the SSNs, then set the macro to open the form. That works, the form opens, I enter the new information, save and close. Go back to the form with that same SSN entered, go to continue entering all the information for that form and it runs the macro again. The only way to get the first form to recognize the new information is to close out the form and open it again.
Moderator
Windows XP Access 2003
Research ReQuery
http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx
and see this
http://www.techonthenet.com/access/c...esh_values.php
Check if record exists, Check Number
How to check if a record exists on the form before running the delete record command
Using Access VBA to check if the record exists in the table
Trouble with check if Exists before Edit or Add Record
Posting Permissions
Reply With Quote