Please help with combo box - choices don't let themselves be chose

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a combo box on a form so that users can pick a sort type before
running a report. The problem is that the types won't let themselves be
chosen. The list shows up but you can't actually pick anything from it. The
strange thing is that I've done this before and it has always worked but for
some reason now it does not. I've compared this combo boxes to ones in the
same database and other databases that work but I can't seem to figure out
what is wrong.
 
Is the combo's Enabled property set to Yes?

Is the form's AllowEdits property set to Yes?

if that doesn't solve it, try adding DISTINCT to the combo's RowSource.
 
And be sure that the combo box is not bound to a field that cannot be
updated in the form's RecordSource query (e.g., a calculated field). And be
sure that you're using an updatable query as the form's RecordSource.
 
The form is unbound. The record source type is Table/Query and the source is
a field in the table. Maybe that's what wrong? Can I use this in an unbound
form?
 
If the form has a RecordSource, then the form is a bound form, not an
unbound form.

If the form indeed is unbound, then the combo box cannot have a
ControlSource value becauese the form contains no fields of data.

Do you mean to say that the combo box's RowSource is a table/query? Give us
the values for the following properties:

COMBO BOX:
Row Source
Row Source Type
Bound Column
Column Count
Column Widths
Control Source
Limit To List
Enabled
Locked

FORM:
Record Source
Allow Additions
Allow Edits
 
Me.OrderBy = Forms!Full Reports2!SortThanks! From reading your post I figured
out that "Allow Edits" had to be set to "Yes". Now it allows me to pick a
value from the field. The only problem now is that the ultimate goal is not
done. This relates to my other thread "Letting users choose how report is
sorted". Now the combo box works but I get an error when trying to open the
report (Enter parameter value Me.OrderBy = Forms!Full Reports2!Sort).

"Full Reports2" is the name of the form and "Sort" is the name of the combo
box.
 
I didn't see that other thread, so I cannot comment about the issue you note
for the report.
 
Back
Top