I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the "beforeupdate" event of the control on the subform but I get a compile error: wrong number or arguments or invalid property assignment.
Can you see what is wrong?
If Not IsNull("[PositionType]", "JobOrderInfo", "[EmployerID] = " & Me.EmployerID & " AND [PositionType] = """ & Me.PositionType & """") Then
MsgBox "Already There"
Cancel = True
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!