I needed to separate a Access 2007 database, tables from forms, queries, programing, etc.
No problem doing that except that a bit of code in BeforeUpdate that checks to make sure entry is not a duplicate entry will no longer work. I’ve tried every suggestion I could find and nothing works. When I reattach tables to the rest of program the code runs perfectly. Very frustrating!!! What can I do???
