Change data in single field using a Query

P

PJ

Greetings,

I have a multi-table database with junction tables for many-to-many links.
I use combo boxes for some ot the standard query data (to enable accurate
queries). Lately, I've been pull out my short hair. I go to a query (or a
form based on that query) and attempt to change combo box data (say "pending"
to "approved."
The combo box drops down as it should, but when I highlight the new
status (approved), I get a beep and nothing happens. No update, no message,
no nuthin'.
I've tried everything I can think of to no success. Has anyone an idea?
 
D

Duane Hookom

Apparently your queries are not updateable. Each join in your query should
have a unique field or fields (primary key) on one side of the join.
 
P

PJ

Thank you Duane, that solved the mystery!
--
PJ


Duane Hookom said:
Apparently your queries are not updateable. Each join in your query should
have a unique field or fields (primary key) on one side of the join.
Click to expand...
 
Top