Coding for duplicate drawing names

[habsfan1986]

I am looking for some help with VB code that will produce the following:


I have 4 criteria to create a drawing number
2letter (XX)
1letter (Y)
DrawingYear (2020)
Number (06)




Full drawing number XX-Y-2020-06


the first three are pull downs and the last is just an inputted number.
I would like to check that the full drawing number (all 4 criteria) is not a duplicate number and have it tell me right away before finishing the the record.

Thanks for the help and suggestions

[orange]

Why concoct a number/identifier?
I recommend the old stand by--- one fact, one field.
What do the letters represent? Why?

Whats wrong with: (explicit facts that you want to record/use)
DrawingID
DrawingNumber
DrawnBy
DrawingCreateDate
DrawingVersionNumber

[habsfan1986]

Why concoct a number/identifier?
I recommend the old stand by--- one fact, one field.
What do the letters represent? Why?

Whats wrong with: (explicit facts that you want to record/use)
DrawingID
DrawingNumber
DrawnBy
DrawingCreateDate
DrawingVersionNumber

First 2 letter designation - facility abbreviation
Second 1 letter designation - group wanting work done - Electricians, Engineeering, etc.

This is the way the manager wants it to be set up so that's what I did.

[orange]

Research DCount(), then a calculation before accepting your code usingg if Dcount(your setup) =0 then no duplicate exists.

However, your manager does not appear to be familiar with relational design concepts. Can you do it as he says, sure.
But do yourself a favor read up on Normalization, the KISS principle and design concepts.
Here's a M$oft link
Don's paper on relational design