query help

  • Thread starter Thread starter Drowning in Queries and Forms
  • Start date Start date
D

Drowning in Queries and Forms

I have created a form based on a query and ultimately, I
want the form to write back to the main table. However, I
keep getting errors on the form, e.g., RecordSet is not
updatable. Everything I've read suggests there is
something wrong with the design of the query, yet I can't
figure out what the problem is.

Any help would be appreciated.

Thanks.

John
 
Hi

You need to supply the query SQL, so that we can tell you
why it isn't updateable.

However I would recommend never basing a form on a query
if it is to be used to update tables. An arragement of
forms and subforms each based on 1 table makes life much
easier.

hth

Chris
 
I have created a form based on a query and ultimately, I
want the form to write back to the main table. However, I
keep getting errors on the form, e.g., RecordSet is not
updatable. Everything I've read suggests there is
something wrong with the design of the query, yet I can't
figure out what the problem is.
Click to expand...

Please open the Query in SQL view and post it here. We can't tell
what's wrong if we can't see the query!

However, some common traps:

- If you have two or more tables in the Query, you must have a unique
Index (such as a Primary Key) on the joining field in the "one" side
table. As suggested, a Form/Subform arrangement is simpler and may be
more appropriate.

- No Totals query, nor any query containing *any* Totals operation
(Sum, Count, Max, Min, etc.) is ever updateable.
 
Back
Top