cannot make selection from a combo box

[Guest]

I have checked the usual things like the properties - not locked, enabled etc
etc for the combo box but it is impossible to have a selection from the drop
down accepted.

Any ideas welcomed.
TIA
James

 

[JK]

Hi James,

This is usually not a problem with the Combo Box (although a possibility
too) but a structure of a query on which the form is based on. eg If the
query is based on two table with a relations to a common field, the "Many"
(ONLY) field of the "one to many" relation must be specified, if used - also
you cannot update a Cross Tab query or a Union Query (there are more.

Look at the query - if there is no "new Record" line (blank line or line
with Default values only at the bottom) the query (thus the form) cannot be
updated - make the changes in the query or create another one until you
have the "new record" line.

If there is a "new Record" line in the query or you don't use a query for
your form there is still a problem in the form and/or the combo box which
is hard to guess when one is flying on instruments.

Regard/JK

 

[Guest]

Well, I think that's a good stab at it 'flying on instruments'. I was coming
to a similar conclusion - namely, I noticed the problem occurred when I
switched from one query as the source for the form to another one. The latter
is more complex (linked tables) whereas the former was simply a query of all
the records in one table.

I'll look closer at the query along the lines you mention and report back.
thanks
James