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

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

Guest

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!!!!
 
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.
 
No I cannot edit in Datasheet view of the query.....do you have any ideas??
 
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..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query and combo box on the form 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Form not allowing edits 2
Form field list 2
Problem with Combo box on form 1
Form Entry Problems 4
Table field name change propogate to queries/reports/forms 1
Combo Box and First Record 5

Back
Top