B
broken_penguin
Hello All,
I have a table with 9 fields that is populated through a form, I am looking
to prevent duplicate records using VBA. This code will need to execute when
the save command button is clicked and trigger a msgbox if all 8 of the
fields are an exact match with the 8 fields in another record. The ninth
field is an autonumber used as a unique id and does not need to be considered.
Form name: input
Table name: records
Fields:
RecordID (autonumber) - this field does not need to be checked
ProjectID (Number)
TypeID (Number)
Box (Number)
Number (Text)
Revision (Text)
Title (Text)
CompanyID (Number)
StartDate (Date/Time)
Any and all help is much appreciated, Philip
I have a table with 9 fields that is populated through a form, I am looking
to prevent duplicate records using VBA. This code will need to execute when
the save command button is clicked and trigger a msgbox if all 8 of the
fields are an exact match with the 8 fields in another record. The ninth
field is an autonumber used as a unique id and does not need to be considered.
Form name: input
Table name: records
Fields:
RecordID (autonumber) - this field does not need to be checked
ProjectID (Number)
TypeID (Number)
Box (Number)
Number (Text)
Revision (Text)
Title (Text)
CompanyID (Number)
StartDate (Date/Time)
Any and all help is much appreciated, Philip