Update on a Form from a Query

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have a query that pulls records that are = to today's date. How do I make
it so that those records are updateable on the form. Every time I do it,
the records are read only.


Greg
The Oft Access Confused
 
Do you have DISTINCT predicate in your query? Open SQL in a datasheed
view and see if the records are updateable there. If they are, does your
form allow editing?

Pavel
 
Could be a number of things;
a. Check the 'Allow Edits', 'Allow Deletions', 'Allow Additions' properties
of the form
b. Check the query design. If the query has more than one table, and any
table is not correctly referenced to another, then the recordset is not
updateable.

You may want to try opening the query directly, and see if you can change a
record. If not, you will need to modify your table structures or query
design...
 
Back
Top