Hello
I am pretty new to Access 2016 and this forum so apologies if this has come up before, though I didn't see it.
I have a form in my database called NewRequests. One of the fields is for an ISBN number stored as short text. If a duplicate value is entered, matched to the table that stores form data Requests2015/16 or a table called RequestsArchive I would like a message box to display that pulls out the previous request number, for example "please not this book has previously been requested, see requests number..."
As multiple service users can request the same book I don't want to stop the request but for the form user to realize a copy is on record.
Can anyone point me in the right direction here?
many thanks
kos2j