Help! Can't edit data using form

[Buddy]

I am very new to programming in Access, so hopefully there is a usual solution to my problem. I created a form from three tables. It displays all of my records very nicely, but I cannot update the data. I checked the properties for the form and all the fields in the form. The form is set to Allow Edits, Allow Additions, Allow Deletions. Each field is set Locks: No; Enabled: Yes. But I cannot edit the data using my form. I saw something online that said that this might be fixed by designing the form based on a query. So I tried that and still have the same problem. I can see the data but not edit it. Again, the properties seem to be set correctly. Does anyone have any idea what I should check next?

Thanks.

Buddy

 

[HiTechCoach]

Since you have multiple tables, are you using a form and sub forms?

If not sub forms, then if you have all three tables in the form's record source, then the record set is probably not updatable.

What is the SQL for the record source of your form?

 

[Buddy]

I am not using subforms. I don't know what the SQL is for my record source....is this shown in properties? (I am at home and can't see my database from here since it is at work....)

So, I could try subforms with one subform for each table and that might work? Will do that first thing in the morning! I would make my form with one table and then add a subform for each of the other two tables? (I will look it all up in Access for Dummies in the AM)

Let me know if you have any other suggestions.

Thanks!

Buddy