Hello everybody. Can somebody help me?
I have a simple "Policies" table, containing some fiew fields, where the Policy Number is the primary key.
I want to create an enquiry form, where I can input a policy number, in a search field, in order to get the single, corresponding record shown in a subform (You can see the mdb here attached).
The problem is that when I type and leave the search field, its value overlaps the Policy Number in the first (current) record of the table. As an example, open the form in the attached mdb and try to search the policy 106.
I don't want the system updates anything and I'd like to show a message like "the policy doesn't exist".
Thanks in advance.