MS Access Forms changed not updating Existing Queries

snowsl00 · #1 (**permalink**) 19-04-2007, 01:48 PM

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?

DJNafey · #2 (**permalink**) 01-05-2007, 08:54 PM

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?

snowsl00 · #3 (**permalink**) 02-05-2007, 02:52 PM

I would like to use my form to change/update contact information as opposed to using a table that has 50 columns.

DJNafey · #4 (**permalink**) 02-05-2007, 03:09 PM

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?

snowsl00 · #5 (**permalink**) 02-05-2007, 04:52 PM

When I update a field on the form, it does not update the query or the table.

snowsl00 · #6 (**permalink**) 02-05-2007, 04:54 PM

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.