Hi folks, looking for help on what may be a simple matter......
I have a text box called "Serial" that is bound to a table called "Enforcement1". I would like to place a list box, or similar, next to the "Serial" box on the form, that will show any duplicates it finds in the "Enforcement1" table, when an entry is placed in the "Serial" text box.
I have searched on the web and found a number of tips but I'm struggling to find one suitable. Most are based on a search box, however I need the Serial number to remain as a record when entered.
Any help, as always, is greatly appreciated.
M
I have a text box called "Serial" that is bound to a table called "Enforcement1". I would like to place a list box, or similar, next to the "Serial" box on the form, that will show any duplicates it finds in the "Enforcement1" table, when an entry is placed in the "Serial" text box.
I have searched on the web and found a number of tips but I'm struggling to find one suitable. Most are based on a search box, however I need the Serial number to remain as a record when entered.
Any help, as always, is greatly appreciated.
M