I have a form dedicated to entering new data into a table. On this form I have a 'CHECK AND SAVE' button that, once pressed, will check whether the value entered in my 'companyjobid' field is unique in my table 'tbljob'.
If the value IS unique then the record may be saved.
If the value IS NOT unique, then the record will not be saved and a message box will appear.
I just can't figure out the syntax of DLOOKUP, which is what I think I need to use.
I have seen this solution which is very similar to what I want, but I can't figure out the syntax.
I already have some code on this button that check all of my required fields for null values. This works a treat, but I need to get this extra code to stop duplicated entries in my 'companyjobid' field.
FYI this field is not the key.