Results 1 to 3 of 3
  1. #1
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116

    Fields get saved in DB when I search!

    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.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    if you are typing supervisor in your search field and the search field is a bound field you're actually changing data. If you want to search your stuff using the criteria of a text box make it an UNBOUND text box and reference the unbound text box NAME in your query criteria.

  3. #3
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    oh thanks! It worked

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search across multiple fields
    By Nexus13 in forum Programming
    Replies: 2
    Last Post: 07-08-2011, 02:38 PM
  2. Help with Search Fields
    By jhawk in forum Forms
    Replies: 2
    Last Post: 03-16-2011, 08:42 AM
  3. Help with Search Fields
    By jhawk in forum Programming
    Replies: 0
    Last Post: 03-15-2011, 08:05 AM
  4. combo box to search multiple fields
    By jo15765 in forum Forms
    Replies: 21
    Last Post: 12-23-2010, 03:28 PM
  5. Entries not saved in fields
    By Lynn in forum Forms
    Replies: 4
    Last Post: 06-02-2010, 09:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums