MS Access Forms changed not updating Existing Queries
-
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?
-
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?
-
I would like to use my form to change/update contact information as opposed to using a table that has 50 columns.
-
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?
-
When I update a field on the form, it does not update the query or the table.
-
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.