Edit data in an Access Form

20 pts.
Tags:
Database
Microsoft Access
I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update with what they type. Every form I've created won't let me type any data. I just get the annoying beep. I'm sure I'm missing something very simple.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Make sure your form properties allow updates, edits, deletes. Also, make sure the query is updateable. Try opening the query and make changes directly to it. If you have any aggregate functions in the query, it won’t be updateable. Also, if you are joining other tables in the query, make sure those tables all have unique indexes.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Lydytunes
    That worked. Took a look at my query along with some of the others I had gotten to work and noticed with the one that wasn't working, I was doing a group by. I created an intial make table query to do the group by and then made my original query reference the new table. By doing that, I was able to get everything to work. I knew it was something simple.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following