Combo Box not accepting input

Question

I created a combo box that is not accepting input from the drop-down list.   I created a duplicate combo box on a blank form based on the same query and it works fine.  Here are some properties and details about the combo box and the form:

Form:

Record Source - None (the form is a popup menu that allows the user to open other forms, reports, etc.)

Parent Control - Tab

Combo Box:

Control Source - None

Row Source - ReportDateQuery (this is a simple query that returns a distinct descending list of dates from the Report table - same query is used on the blank form above that works)

Bound Column - 1  (the query only returns one field)

Column Count - 1

Enabled - Yes

Locked - No

Events - None

The blank form where the combo box works is identical except that the combo box control is not within a tab control.  The blank form has only the combo box.

When I open the form in form view and click on the combo box, the list of dates that I expect to see appears, but when I select a date, nothing happens.  The value is not shown in the combo box.  As long as the focus remains on the combo box, the drop-down list remains shown.  Using the Immediate window and debug.print commands I can see that the combo box is known, but contains Null:

Debug.print forms!databasemenu!reportcombo.name

reportcombo

debug.print forms!databasemenu!reportcombo

Null

Executing the same for the blank form returns the value shown in the combo box.

Why won't the combo box accept input?

Answer 1

Check the Allow Edits property of the form. Even if the form is unbound, setting Allow Edits to No will effectively lock all controls.

Answer 2

Of course!!!  That worked and I knew it would be something easy I hadn't thought to change.

Thanks very much!

Answer 3

@Scottgem: the OP mentions "Locked - No" in the first post of this thread.

Answer 4

Could the control be locked? If selecting an item in the list doesn't not show the selection in the control. that is what would happen.