Hi Folks.
I want to have a field on my Access Form check to see if the record i'm about to add already exists based on the text value of the Field I am about to enter data into so essentially, something on the 'After Update' event that checks if that value already exists, if so takes me to that record, if not, proceeds with the data entry. Tried working my way through this with Macros with no joy so hoping someone has a vba answer?
thanks in advance.