This is going to sound strange and so it is. The problem is in Access XP.
I have a listbox on a form with the names of various room names for a house. The objective is to have the user double-click any of the room names and that room will be added to a subform that is updated to show the room's addition.
The problem arises when there are no rooms that have been added to the subform. This occurs when the form is first used or after all the rooms have been deleted from the subform.
When any room in the listbox is selected by a double click, Access does not pick up the string text. In the OnDblClick event the value for the listbox is null and a cryptic Access error is displayed. "0 - ".
After clicking ok, the form is available and there are no problems double clicking thereby adding rooms to the subform.
Is anyone familiar with this behavior?
Regards, Sorrells
I have a listbox on a form with the names of various room names for a house. The objective is to have the user double-click any of the room names and that room will be added to a subform that is updated to show the room's addition.
The problem arises when there are no rooms that have been added to the subform. This occurs when the form is first used or after all the rooms have been deleted from the subform.
When any room in the listbox is selected by a double click, Access does not pick up the string text. In the OnDblClick event the value for the listbox is null and a cryptic Access error is displayed. "0 - ".
After clicking ok, the form is available and there are no problems double clicking thereby adding rooms to the subform.
Is anyone familiar with this behavior?
Regards, Sorrells