Hmm. Form from Query not allowing update

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

Greg

I have a form that I created from a query with the stipulation that only the
records =Date() be seen.

I made the form, but it will not allow me to update the information. Anyone
know why?


Greg
 
Several possibilities.
1) Look in the Form's property sheet Data Tab....
The form is set to 'AllowEdits = No'
or 'AllowAdditions = No'
or 'AllowDeletions = No'
or 'DataEntry = Yes'
Set DataEntry to No; all the others to Yes.

2) The query record source itself in not updateable.
Open the query. Is the AddRecord navigation button
grayed out? Can you make a change to the data in the query?

Certain types of queries are not updateable.

Look in Access help for updateable queries.
 
Back
Top