Hmm. Form from Query not allowing update

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
 
F

Fredg

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