can't add data to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Most Queries containing Calculations are not updateable - verify by trying
to enter data into the query
You must put the calculations on (unbound) form controls instead...

HTH

Pieter

rawley said:
I've created a form based off of a query (so that the form automatically
Click to expand...
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?
 
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".

--
HTH
Van T. Dinh
MVP (Access)


rawley said:
I've created a form based off of a query (so that the form automatically
Click to expand...
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?
 
Back
Top