Editing Query Data Problems

  • Thread starter Thread starter davepidgeon
  • Start date Start date
D

davepidgeon

Hi,

I've got a problem editing data from a query. I've got a form with two
combo boxes both linked to different tables. When the user selects the
values (they can also be both left blank) they click search and this
then brings up a form (which is linked with the query) - basically it's
a parmeter query but is linked to a form, I used
http://www.fontstuff.com/access/acctut08.htm to be able to it. The data
displays fine, but for some reason I cannot edit any thing.

I can edit the data in the table fine, and I've got another form which
is linked directly to the table where the data lies and that works fine
too. I've checked to make sure that everything isn't read-only etc,
and the form allows editing but still no joy.

Any help would be great,

Dave
 
Hi Dave - go to your help and type 'edit data in query' in the answer wizard
tab - this gives info on when you can and can't update from a query. Yours -
Dika
 
Hi,

I've got a problem editing data from a query. I've got a form with two
combo boxes both linked to different tables. When the user selects the
values (they can also be both left blank) they click search and this
then brings up a form (which is linked with the query) - basically it's
a parmeter query but is linked to a form, I used
http://www.fontstuff.com/access/acctut08.htm to be able to it. The data
displays fine, but for some reason I cannot edit any thing.

I can edit the data in the table fine, and I've got another form which
is linked directly to the table where the data lies and that works fine
too. I've checked to make sure that everything isn't read-only etc,
and the form allows editing but still no joy.
Click to expand...

Not all queries are editable. I doubt it has anything to do with the
combo boxes; it's a problem with the Query upon which the form is
based.

Some common reasons: there must be a unique Index (such as a Primary
Key) on the joining field in the "one" side table, and a nonunique
index on the joining field in the other table. Or, if your query
contains ANY Group By, Sum, Count or other totals query operation, it
cannot be updated; similarly setting the query's Unique Values
property will block updating.

If this doesn't help please post the SQL view of the query.


John W. Vinson[MVP]
 
Hi John,

Thanks a lot for your help. A HUGE school boy error on my part not
defining a primary key in the table that the query was running from,
really don't know what I was doing! Working fine now!

Thanks a lot for your help :)!!!

Dave
 
Back
Top