Hi all

Is this an Access 2007 bug?

I have an unbound listbox on a form that is linked to a query which is dynamically produced (I have verified that when the listbox loads the query exists and runs independently of the form)

The listbox is intended to drive the recordset of a subform.

The Listbox displays the appropriate data, however, none of the rows are selectable

The subform is blank as no listbox values have been set.

The following conditions apply:

The query the listbox is based on allows additions (it has a * row when run independently)
The form (and subform) both allow additions, deletions, edits and filters (though sometimes the sfm reverts to not allowing these, even though it is saved to allow them)

When I go into form design view and back into form view without making design changes, the listbox is selectable and works as expected.

Can anyone suggest what to check next?

__________________
Rob Carter