Prevent entry of duplicate Personal ID Number

[jerryg72]

Hello friends, I am a novice in MS Access. My employee database has a field for serial number which is Autonumbering, and I have another field to enter his 12 digit personal ID Number (similar to SSN). First of all, prior to adding his personal details I need to make sure that his Personal ID number is not entered already, I need to prevent entering duplicate Personal ID number. Make note that this field is Indexed Yes (No Duplicates). Moreover I want to restrict entering data on all other fields prior to entering his unique personal ID number. Is there a way to to do this? Your help is greatly appreciated. Thanks

[June7]

Use textbox BeforeUpdate event to validate input with DLookup() domain aggregate function.

Set other controls as disabled in design then use ConditionalFormatting to enable after input of ID Number. Set a rule that ID Number textbox is not null.

[ranman256]

at text box ID entry:

this code assumes the ID is text (not numeric)

vID = Dlookup("[PersID]","table","[PersID]='" & txtID & "'") & ""
if vID <> "" then
   msgbox "This ID exists"
   exit sub
endif

'otherwise add the new entry

[jerryg72]

Personal ID is numeric

[orange]

Please give a couple of examples of your PersID. How is PersID defined in your table?

[jerryg72]

These are just a 12 digit number...eg: 278051201235. First "2" represents the class/grade, 2-7 digits are his birthday and the last 5 is the sequence/series

[orange]

I'm pretty sure this is a text field with only numeric characters. Show the definition in the table.
Did you try the suggestions from the others?
Relational databases work very well with 1 fact, 1 field (atomic data). Personal/custom combination/codification of several fields can be treacherous --just sayin'. But individual field definitions and then subsequent concatenation for display is quite common.

[jerryg72]

You are right. This is a text field with numeric characters.

[orange]

So, did the advice of June and ranman work?