I can't update any fields in my form?

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

Guest

I am unable to update any fields in the form, however i can update anywhere
else. The form includes two date fields for users to input and then a
calculated field where I am getting the difference between the two dates. I
thought it was because of my calculations so I deleted them and redid the
form but i'm still unable to update anything. When I go to the query and
enter the dates Access calculates perfectly and then displays them in the
form. Why can't I enter the dates or other info. on the form. I have
checked the form properties and it's set to allow deletions/additions/edits
and it is not locked.
 
Are there other controls on the form that you can update? Although the
form's properties may be set correctly, are the text boxes' properties set
to locked? Is there an incorrect input mask on the controls that isn't
letting you enter the data? Is there any code in a Key Press, Down, Up event
that may be interfering? Is the form's Key Preview property set to Yes? What
code is behind the form or its controls (i.e. which events, if any, are you
using)?

If I understand you correctly, if you open the query that is the form's
Record Source, you are able to make the edits in THAT query.
 
Back
Top