Can't edit fields in form (1 Viewer)

ZenDiagram · Sep 13, 2018

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 · Sep 13, 2018

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 · Sep 13, 2018

db is too big to attach.

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

Thanks!

plog · Sep 13, 2018

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 · Sep 13, 2018

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 · Sep 13, 2018

plog said:
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 · Sep 13, 2018

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 · Sep 13, 2018

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 · Sep 13, 2018

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 · Sep 13, 2018

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.

Pat Hartman · Sep 13, 2018

Forms that need to interact with data (add/edit/delete) should be based on tables, not queries.

My forms are ALWAYS bound to queries so I can control the rows returned. Many contain multiple joins to other tables or queries. Queries are always updateable unless some part of them is not. There are numerous articles on this topic. the primary reason that queries are not updateable is because they include aggregation or join to a query that aggregates data.

Typically when you join to lookup tables, you should lock the fields on the form to prevent accidental updating. An example is an order entry form. You always want to show Customer information so the form is bound to a query that joins tblOrders to tblCustomers. However, you do NOT want to allow updates to the Customer info from the Order form since it would change the Customer info on the customer table.

missinglinq · Sep 14, 2018

ZenDiagram said:
...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)>

Pat Hartman · Sep 15, 2018

Why do you have two open questions on this topic?

Can't edit fields in form (1 Viewer)

ZenDiagram

Registered User.

Ranman256

Well-known member

ZenDiagram

Registered User.

plog

Banishment Pending

ZenDiagram

Registered User.

ZenDiagram

Registered User.

plog

Banishment Pending

ZenDiagram

Registered User.

plog

Banishment Pending

ZenDiagram

Registered User.

Pat Hartman

Super Moderator

missinglinq

AWF VIP

Pat Hartman

Super Moderator

Similar threads

Users who are viewing this thread