Experts thank you in advance !
I am looking to check if a field [BillItem] has a duplicate on a continuous form and loads accustom message instead of the standard access message.
thought I had sorted using Dcount but the formula I was using does not work for a continuous form as it calls the message box even if the next line entry is not a duplicate.
The code that does not work was used for a form for a single field so not sure how to convert for a continuous form
'***** This Code does not work for a contionous form !!! ********
'Private Sub BillItem_AfterUpdate()
'If DCount("*", "updateprojectbill", "billitem= " & Me.BillItem) > 0 Then
'BillItem.BackColor = RGB(255, 182, 193)
'MsgBox "Duplicate Bill Item! Please allocate a different Bill Item.", vbInformation, "CMWorkflow Data Required"
'BillItem.BackColor = vbWhite
Your help to amend the code to work would be much appreciated. I have attached some screen shots