Form won't allow changes after I updated my table and queries

C

Creush

Need Help...
I deleted a field (Senority #) in my table and so on with the queries,
forms. reports that had that field. I redone my query so that it would
calculate my senority (thanks to all that helped). When I went back into my
form that previously had the senority field I could not edit or change
anything. All I got were beeps. I do not have any locks on the text boxes,
combo boxes, forms, ect. Please help!!!!
 
V

Van T. Dinh

You new Query may not be updateable.

Open the Query by itself, i.e. not through the Form and see if you can edit
in the DatasheetView of the Query.
 
V

Van T. Dinh

Check Access Help topic "Updatable Queries" which has brief explanation when
a Query is updateable or not and also a few techniques to convert a
non-updateable Query to become updateable..
 
Top