If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change data in single field using a Query
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? -- PJ |
#2
|
|||
|
|||
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. -- Duane Hookom MS Access MVP "PJ" wrote in message ... 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? -- PJ |
#3
|
|||
|
|||
Thank you Duane, that solved the mystery!
-- PJ "Duane Hookom" wrote: 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. -- Duane Hookom MS Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |