Can't edit fields in form

[ZenDiagram]

Database attached.

Please look at my form "frm_Rollback".
I need to be able to edit the fields that are not calculated.
But I can't.

 

[Ranman256]

is the query a snapshot?
is the form set to locked?
are the text boxes set to locked?
does the query have joins to other tables? (this can be Read Only)

 

[ZenDiagram]

db is too big to attach.

any idea why i cant edit the controls in my form?

Thanks!

 

[plog]

No database attached, but I'll make an educated guess that your form is based on an unupdateable query.

Forms that need to interact with data (add/edit/delete) should be based on tables, not queries. If you need to do a calculation, have the form do it by placing that calculation as the source of an unbound text box.

 

[ZenDiagram]

is the query a snapshot?
-I don't know what that means. I am a beginner.

is the form set to locked?
- don't know how to figure this out

are the text boxes set to locked?
- same as above

does the query have joins to other tables? (this can be Read Only)
- same as above

 

[ZenDiagram]

No database attached, but I'll make an educated guess that your form is based on an unupdateable query.

Forms that need to interact with data (add/edit/delete) should be based on tables, not queries. If you need to do a calculation, have the form do it by placing that calculation as the source of an unbound text box.

Plog,
Is a query always un-updateable?

 

[plog]

No, some queries are updatable. The simpler they are (less joined tables, no aggregation), the more likely they are to be updatable. I'm sure there's some rule or explanation as to what makes it unupdatable, but I make my life simple by using this rule---forms that update data should be based on tables.

 

[ZenDiagram]

I'm recreating the form based on the table.
I can edit everything just fine until I add fields from other tables.
Then it wont let me edit the original fields anymore.

 

[plog]

Huh? The Record Source of your form can only be 1 object (table or query). How are you adding other fields from other tables?

 

[ZenDiagram]

in design view, I click "add existing fields" in the upper ribbon.
In the "field list" box I click "show all tables" then select fields from other tables.
I see now that I should only use fields from existing record source only.
ugh.

I guess I could add subreport to my form to show information from other tables that are pertinent.

 

[missinglinq]

...I can edit everything just fine until I add fields from other tables...


...In the "field list" box I click "show all tables" then select fields from other tables...

When you add Fields form another Table, Access is actually changing your Form's RecordSource from a Table to a Query...which can entail the kind of problem you're facing.

Allen Browne has an excellent article discussing many of the reasons a Query can be Read-Only:

Why is my query read-only?

Linq ;0)>