if dcount("PatientID","[tblPatient]","[SSN] = '" & me.txtSSN & "'") = 0) then
' Allow insert
else
msgbox("SSN Already Exists in Database.")
endif
That's about as specific as I can get with the information provided.
Neil Squires
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of chrisman052003
Sent: Thursday, December 08, 2005 2:48 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Data Input Question
I want the system to check the table and if a serial number already
exist, then the user would be informed that serial number already in
system.
Thanks
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
