| | |
|
|
|
can't add data to form |
|---|
| message from =?Utf-8?B?cmF3bGV5?= on 5 May 2004 |
I've created a form based off of a query (so that the form automatically performs calculations based-on values entered), but for some reason, I can't edit any of the data already entered (entered from a table), and I can't add any new data. I've verified that the queries are set to "Dynaset" and not "Snapshot". Anyone have any ideas?
Thanks!
|
| Pieter Wijnen replied to =?Utf-8?B?cmF3bGV5?= on 5 May 2004 |
Most Queries containing Calculations are not updateable - verify by trying
HTH
Pieter
"rawley" <anonymous@discussions.microsoft.com> wrote in message
news:EB0529E4-C5DE-4813-B2E4-27CB22E39139@microsoft.com...
performs calculations based-on values entered), but for some reason, I can't
edit any of the data already entered (entered from a table), and I can't add
any new data. I've verified that the queries are set to "Dynaset" and not
"Snapshot". Anyone have any ideas?
|
| Van T. Dinh replied to =?Utf-8?B?cmF3bGV5?= on 6 May 2004 |
The Query, especially if you combined 2 or more Tables, may not be
updateable.
Open the Query by itself and see if the "NewRecord" button is enabled or
not. If it is disabled, your Query is not updateable. You can also try
modifying the data on the DatasheetView of the Query.
Check Access Help on "Updatable Queries".
|
|
Archived message: can't add data to form (Microsoft Access Error Message)
