I'm using Access 2002.
Part1 All my formes are opened in edit mode in order to be able to do a search, I noted if you open for add (makes sense)you cannot do a search.
However, I have one form that acts as though it was opened for add no matter what I do because when I click on the search button, created with a wizard, I get: You can't use find or replace now.
Part 2 How or can better control whether or not a form comes up with empty fields. I'm really confused some of the forms come up filled in some don't, and they are all opened in edit from my switchboard?