Combo doesn't allow selection

X

XP

Using Office 2003 and Windows XP;

I have a subform on a form; the subform was created separately and contains
all columns from a table; the subform opens in datasheet view.

On the main form is a combo; I have its row source set to a query to provide
a list of departments.

When the department is changed, I want the subform to filter on the
department selected in the combo. I have done this before without problems,
but this time when I open the combo, it locks in the sense that it won't let
me select anything in the list of departments in the drop down.

I'm sure it's something stupid. Please help if you can; thanks.
 
R

Rick Brandt

XP said:
Using Office 2003 and Windows XP;

I have a subform on a form; the subform was created separately and
contains all columns from a table; the subform opens in datasheet
view.

On the main form is a combo; I have its row source set to a query to
provide a list of departments.

When the department is changed, I want the subform to filter on the
department selected in the combo. I have done this before without
problems, but this time when I open the combo, it locks in the sense
that it won't let me select anything in the list of departments in
the drop down.

I'm sure it's something stupid. Please help if you can; thanks.
Click to expand...

The ComboBox could be set to Locked = True.

The Form could be set to AllowEdits = No

Is the ComboBox bound? From your description of usage it sounds like it should
not be. If it is then the RecordSource of the form could be non-editable.
 
Top