Re: [MS_AccessPros] I cannot edit data using query or form

 

Jorge-

If you cannot edit the data in the query, then you won't be able to edit in a form based on the query.  You've done something in the query to make it not updatable.  Please post the SQL.  (Open your query in Design View, switch to SQL View, then copy and paste the text you see.)

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Dec 11, 2016, at 7:27 PM, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning, here I am again, trying things out.

I am doing a tutorial and they suggested that I using a different table to keep phone numbers, email and address for a contact.

These is a fantastic idea, it allows me to enter multiple items for a customer: Phone, email and address.

I am using a query to pull out the customer name, last name, default email, phone and address.

It works well but I cannot edit the data in the table using the query.

I did a form base on the query, I cannot edit the fields there either.

What am I doing wrong?

Please help!!

The tables I am using are:

tblPerson

tblPersonEmails

tblPersonPhNummers

tblPersonAddresses

 

Thanks

Jorge Muralles

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___