Using a simple example, say I have a database full of employees.
On the main start-up form I have a button to find an employee by last name. Say there is a record with the following info:
First Last Extension Email
Jack Brown 1111 Jack_Brown@email.com
To make the front form look clean I have it set to go to a new record - this makes the "find employee" section blank rather then showing the first last name in the database. The problem is since I have defined a new record to make it blank, it then tries to write whatever i have in that box to a new record. So If I search "Brown" it will work, but when i close the form it will write a new record. Here is an example.
First Last Extension Email
Jack Brown 1111 Jack_Brown@email.com
Brown
It makes a new record and populates the last name with what I searched for. I attempted to solve this by setting the primary key as the email address. But now it still tries to make a new record, but pops an error up stating that the primary key can not be null.
So how do I have a blank form (in other words, not pre-populated with the first last name) without creating a new record? I considered having a blank record first, but then I would have to write queries to exclude that blank record from every report and such.
Thanks for any suggestions.