Combo Box

Barry and John,
Thank you both for the help and insight. I've read the updateable help
topics and have checked much of the info you've provided. At this point, I'm
going to put the combo box on a subform based only on the table needed and
see if it will work any better.
Thanks again for your time and help. As always, very much appreciated!
Pam

"John Vinson" wrote:

On Wed, 25 Oct 2006 13:51:02 -0700, PHisaw
wrote:

The query isn't updateable. I looked at all you suggested and still can't
figure out why.

Take a look at the Access Help for "updateable". Some common issues:

- no Totals query, or any query containing any totals operation, is
ever updateable
- No UNION query is updateable
- If the Query's Unique Values property is set, it won't be updateable
- If you have two or more tables joined, there must be a unique Index
(such as a primary key) in the "one" side table's join field, and a
relationship defined between the tables. Not all multitable queries
are updateable, and they can be confusing, giving multiple
partially-duplicated records. It's generally best not to use
multitable queries as form recordsources.

John W. Vinson[MVP]