Alright, here goes. I jus noticed something super strange in my forms. I have 2 forms: One to enter values into a DB and the other to search for information from DB. All the fields are same in both the forms and point to the same DB. If I have 40 rows in the DB I get the information "1 of 40" records for both the forms (btw, is there any way to change this for the search forms?)
Now, I am in the search form and I search for "Supervisor" in the Designation field. If the 1st column in the DB has a value in the designation field then everything is fine, but if there is no value in the 1st column for the designation field and I enter "Supervisor" in the search form, then the value gets saved in the DB!
I imagine this happens since both the forms point to the same table and the problem is that the search form can also enter values into the DB.
Not sure how much sense I am making here, but it would be great if anyone can help me.