I have a database with movies. Before, I used an Excel spreadsheet, and whenever I typed the name of the movie in the “Title” column, I could immediately see if the name I typed already existed in that column. This does not happen in my database.
Can someone tell me if I can get the same result with a macro? Many thanks in advance.
Use a Combo Box in a form.
There is a table “mytable” connected to the form. The table has column “Title”. The Combo Box will be linked to the “Title”. Now set the code for SQL in the Combo Box: SELECT DISTINCT "Title" FROM "mytable" ORDERED BY "Title". Existing values will be available, new values could be added.
Thank you for the tip, RobertG. I’ve tried it and it worked… better than I expected. When I press the “New record” button on the form, the combo box where I enter the new title reacts as I wanted, as I add one more letter. I never thought of this possibility. My sincere thanks.