Devil's form can not be edited!!!

[albe_ACC]

Hi guys!!
I have a terrific question about a form! (I called it the "devil's form"!)

I need to edit a specific field of the form, in order to insert a value for each line of the table visualized in the aforementioned form.

I assume there's a problem with the query I use but...I can't get out of it!
Is there a way the form can allow me to edit that field??

I attach Satan himself here!



Thank u very much for your time!

[June7]

The RecordSource for the form is a query of the two tables but the tables are not related by a JOIN clause. The RecordSource is not updatable and that's why you can't edit the bound textbox. Probably should be a form/subform arrangement if these tables have a one-to-many relationship. I can't figure out what their relationship is, if they even have one. I think your database structure is fatally flawed.

[albe_ACC]

Thank you for your answer!!!!!!!

I try to give you a more explicative example.
I have:
a table with dog names
a table with owner names/ages
a table that says the owner of each dog
and i want to insert, through the form, the dog's age in the previous table.

Even with a join, it does not work :S
Is there any suggestion you would give me?
Thank u again for your time and precious support!

[June7]

1. Need primary keys in Dogs and Owners tables. Since you are saving the names, the name fields can be primary keys. It is not good practice to use names as primary key. If you don't want keys (no table relationships) then don't include Dogs and Owners tables in the form RecordSource.

2. Because you are saving names, don't need Dogs table in query (table has no other info). Include Owners table only because you want to show owner age. Query would be:
SELECT [dog-owner].dog, [dog-owner].dog_age, Owners.Owner_name, Owners.Owner_age FROM Owners RIGHT JOIN [dog-owner] ON Owners.Owner_name=[dog-owner].owner;
But if you want to include Dogs table, query would be:
SELECT [dog-owner].dog, [dog-owner].dog_age, Owners.Owner_name, Owners.Owner_age FROM Dogs RIGHT JOIN (Owners RIGHT JOIN [dog-owner] ON Owners.Owner_name=[dog-owner].owner) ON Dogs.Dog_name=[dog-owner].dog;

3. Put all the textboxes in the Detail section. Labels can go in Form Header.

4. Dog and Owner textboxes should be bound to fields of Dog-Owner table.

5. Set form to Continuous view.

6. Cannot add new records to Dogs or Owners from this form setup.