MS Access Forms changed not updating Existing Queries

  1. #1
    snowsl00 is offline Newbie

    MS Access Forms changed not updating Existing Queries

    I am using Access 2003 simple contacts database and am new to using it and no nothing about coding. All contact information has been entered into the database table and I have created a "Form" to make viewing and editing easier. But, when I update the "Form", it does not update any queries I have created. Can anyone help?


  2. #2
    DJNafey is offline UK site moderator
    Normally, a form is just a pretty way of viewing a table. The queries are the "code" that retrieves or updates information from the tables. Forms wouldn't normally be able to change queries. Could you clarify what you're expecting to be happening?

  3. #3
    snowsl00 is offline Newbie
    I would like to use my form to change/update contact information as opposed to using a table that has 50 columns.

  4. #4
    DJNafey is offline UK site moderator
    Do you have the record selector displayed at the bottom of the form? That should allow you to scroll through records and also add a new one. If you do it like that, does a change to an existing record update the table when you move to a different record?

  5. #5
    snowsl00 is offline Newbie
    When I update a field on the form, it does not update the query or the table.

  6. #6
    snowsl00 is offline Newbie
    Sorry, trying again. Record Selector is visible and when I update a field on the form, it does not update the Query or the Table.

+ Reply to Thread