Update on a Form from a Query

[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

 

[Pavel Romashkin]

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

 

[Ruskin Hardie]

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...