K
kiln
This is a bug I've run into over time that I might as well see if anyone
has info on.
A very simple (Access 2000 fully patched) form is set to continuous
view. The query underlying this form is limited by three criteria that
refer to unbound fields on header of the form; two textboxes for dates
and one combo for a text value. The afterupdate event of all three
fields has code that requeries the form (Me.Requery). That is all the
code these three fields have behind them. The combobox that is used as
for criteria is bound to a very simple query based on a single column
table.
If I select criteria values for the three fields that return records,
fine. If I select criteria in any of the fields that returns no records,
the field is blanked out. By that I mean the combo selection text or the
textbox value vanishes. The value is still there, if I check by code.
The combo, if opened via mouse, shows a black selected area where the
text should be, but the text itself is not visible.
The behavior is identical on two very different computers, so I'd guess
it's not a video driver issue.
And the bug seems to be linked to the after update event which initiates
the form requery in the test above. If I rem the code for the criteria
field's after update event, and simply requery the form with a command
button, the values of all three fields are left intact and visible even
if the form returns no records.
Finally, exporting this db to Access 2002 file format shows that the
behavior persists in Access 2002.
has info on.
A very simple (Access 2000 fully patched) form is set to continuous
view. The query underlying this form is limited by three criteria that
refer to unbound fields on header of the form; two textboxes for dates
and one combo for a text value. The afterupdate event of all three
fields has code that requeries the form (Me.Requery). That is all the
code these three fields have behind them. The combobox that is used as
for criteria is bound to a very simple query based on a single column
table.
If I select criteria values for the three fields that return records,
fine. If I select criteria in any of the fields that returns no records,
the field is blanked out. By that I mean the combo selection text or the
textbox value vanishes. The value is still there, if I check by code.
The combo, if opened via mouse, shows a black selected area where the
text should be, but the text itself is not visible.
The behavior is identical on two very different computers, so I'd guess
it's not a video driver issue.
And the bug seems to be linked to the after update event which initiates
the form requery in the test above. If I rem the code for the criteria
field's after update event, and simply requery the form with a command
button, the values of all three fields are left intact and visible even
if the form returns no records.
Finally, exporting this db to Access 2002 file format shows that the
behavior persists in Access 2002.