Thanks Neil, As always, my attempt was a little syntax problem and your code pointed out the missed '. Thanks --- In [email protected], "Squires, Neil" <[EMAIL PROTECTED]> wrote: > > 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: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of chrisman052003 > Sent: Thursday, December 08, 2005 2:48 PM > To: [email protected] > 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/
