combo box not selecteable

[Bill - ESAI]

I can't for the life of me figure out why I can't make a selection from any
of 4 combo boxes I have on my form. The form itself has a query as a record
source and each of the combo boxes has a control source. Each also has a
query in the Row Source.

When the form loads each combo box is populated with the correct default
value and the result set for each in their queries are all listed but none
are selectable. How can I make these lists selectable??

Bill

 

[Klatuu]

Most likely, the query that is the record source for your form is not
updatable.
If you have the form navigation buttons exposed, look to see if the button
to the right with the * is greyed out (disabled). That means the form's
record souce in not updatable.
Some queries, by their nature, cannot be updated. Union queries, Totals
(Group By) queries, and some queries using multiple tables or other queries
can't be updated because it is not possible for the query to know which field
in which record in which table should be updated.

 

[Bill - ESAI]

Doh. Back to that again. :-(

TY

Bill

Most likely, the query that is the record source for your form is not
updatable.
If you have the form navigation buttons exposed, look to see if the button
to the right with the * is greyed out (disabled). That means the form's
record souce in not updatable.
Some queries, by their nature, cannot be updated. Union queries, Totals
(Group By) queries, and some queries using multiple tables or other
queries
can't be updated because it is not possible for the query to know which
field
in which record in which table should be updated.

 

[Bill - ESAI]

OK, I now have an updateable query and I can add and edit results but only
after I've added some and only the ones I just added. If I add a few and
close the application then re-open it the ones I added previously don't show
in the resultset. In fact, there is nothing there unless I added them again
however, the records are still in the table. If I added them again then
there will be two sets of the same records.

Here's how I have it set up:

Main Form
Record Source: SELECT EmpMilestones.* FROM EmpMilestones ORDER BY
EmpMilestones.EmployeeAlias;
Order By: EmployeeAlias
Default View: Single Form
Allow Form View: Yes
Allow Datasheet View: Yes
Allow PivotTable View: Yes
Allow PivotChart View: Yes
Allow Edits: Yes
Allow Deletions: Yes
Allow Additions: Yes
Recordset Type: Dynaset
Record Selection: Yes
Navigation Buttons: Yes

I think that's about unless I'm missing something.

Each form element has a Control Source Set to it's corresponding value from
the form Record Source.

Like I say, I can add items and they are inserted into the table but they
won't display if I close and re-open the form.

Bill

 

[Bill - ESAI]

That did the trick.

Thank you so much.

Bill

 

[Klatuu]

Good catch.