Can't Edit Table Through My Form

[Coby]

I am trying to edit a table through a text box on a form instead of
directly in the table, but cannot edit the data.

1. The form is set up with its own query as a recordsource to a
table.
2. Control source for the text box on the form bound to a field in
the table recordsource at the control source.

3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
Additions are all set to yes.

It seems like I have everything set up logically to do this, but I am
stumped because I cannot edit anything on the form for some reason.

Any helped on what I am doing wrong would be appreciated.

Stumped,
Coby.

 

[John W. Vinson]

I am trying to edit a table through a text box on a form instead of
directly in the table, but cannot edit the data.

1. The form is set up with its own query as a recordsource to a
table.
2. Control source for the text box on the form bound to a field in
the table recordsource at the control source.

3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
Additions are all set to yes.

It's very likely that the Query itself is not updateable. Not all queries are!
Totals queries, Unique Values queries, UNION queries, etc. all block updating.

Try opening the query itself in datasheet view. Is there a *> new record row
at the bottom? If not, that's the problem. You could open it in SQL view and
post the SQL text here for help in making it into an updatable query.

John W. Vinson [MVP]

 

[Coby]

It's very likely that the Query itself is not updateable. Not all queries are!
Totals queries, Unique Values queries, UNION queries, etc. all block updating.

Try opening the query itself in datasheet view. Is there a *> new record row
at the bottom? If not, that's the problem. You could open it in SQL view and
post the SQL text here for help in making it into an updatable query.

John W. Vinson [MVP]

Thanks for your help! I appreciate if a lot. Here is the sql text:

SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU

FROM MaryLumTransDb

GROUP BY MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU, MaryLumTransDb.ThickActual,
MaryLumTransDb.WidthActual, MaryLumTransDb.Length

ORDER BY IIf(Me!Option8801.Value=True,MaryLumTransDb.
[8801_ActiveStatus],MaryLumTransDb.[8806_ActiveStatus]) DESC ,
MaryLumTransDb.ThickActual, MaryLumTransDb.WidthActual,
MaryLumTransDb.Length;


Coby.

 

[Rick Brandt]

It's very likely that the Query itself is not updateable. Not all queries
are!
Totals queries, Unique Values queries, UNION queries, etc. all block
updating.

Try opening the query itself in datasheet view. Is there a *> new record row
at the bottom? If not, that's the problem. You could open it in SQL view and
post the SQL text here for help in making it into an updatable query.

John W. Vinson [MVP]

Thanks for your help! I appreciate if a lot. Here is the sql text:

SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU

FROM MaryLumTransDb

GROUP BY [snip]

A query with GROUP BY is NEVER editable.

 

[Coby]

Thanks for your help! I appreciate if a lot. Here is the sql text:

SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU

FROM MaryLumTransDb

GROUP BY [snip]

A query with GROUP BY is NEVER editable.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com- Hide quoted text -

- Show quoted text -

That did it . . . and now makes complete logical sense to me. I
didn't even need the group by in this particualar query anyhow. Most
of my work involves querying data for reporting and have only recently
needed to acually write to the data, so group by just became habit
when writing a new query since I am often using a lot of sum
functions, etc.. Thank you very much! My work is all cut out for me
for awhile now.


Coby.

 

[Guest]

What is the SQL of the query for your form?

You can view the query in SQL view and paste the SQL from there.

Some types of query are not updateable, e.g. those that have a GroupBy
clause...

Steve

 

[Guest]

You should never use Group By unless it is absolutely necessary. It will make
your queries less efficient.

Steve

On Aug 16, 4:43 pm, John W. Vinson
I am trying to edit a table through a text box on a form instead of
directly in the table, but cannot edit the data.

1. The form is set up with its own query as a recordsource to a
table.
2. Control source for the text box on the form bound to a field in
the table recordsource at the control source.

3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
Additions are all set to yes.

It's very likely that the Query itself is not updateable. Not all queries
are!
Totals queries, Unique Values queries, UNION queries, etc. all block
updating.

Try opening the query itself in datasheet view. Is there a *> new record row
at the bottom? If not, that's the problem. You could open it in SQL view and
post the SQL text here for help in making it into an updatable query.

John W. Vinson [MVP]

Thanks for your help! I appreciate if a lot. Here is the sql text:

SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU

FROM MaryLumTransDb

GROUP BY [snip]

A query with GROUP BY is NEVER editable.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com- Hide quoted text -

- Show quoted text -

That did it . . . and now makes complete logical sense to me. I
didn't even need the group by in this particualar query anyhow. Most
of my work involves querying data for reporting and have only recently
needed to acually write to the data, so group by just became habit
when writing a new query since I am often using a lot of sum
functions, etc.. Thank you very much! My work is all cut out for me
for awhile now.


Coby.