[AccessD] AXP Combobox Shows blank formatted date column

Charlotte Foust cfoust at infostatsystems.com
Thu Mar 3 13:03:45 CST 2005


We have a client installation where certain machines running Windows
2000 are seeing an odd behavior in a combobox that displays two columns,
a report number and a medium formatted date.  We have not been able to
reproduce the behavior here even on Win2k, so I need some ideas. The
back end is SQL Server 2000 and the combobox has this for a rowsource:

SELECT  ReportNo, ReportNo as [Number], Format(ReportDate, "dd-mmm-yy")
FROM DailyDrillHdr WHERE
((DailyDrillHdr.WellID=[Forms]![frmDailyRpt]![cboWellID])) Order by
ReportNo desc;

This works fine when the form opens and a WellID is selected.  It breaks
when the user brings up a popup form that allows them to select a
different WellID and hand that back to the initial form.  The initial
form obligingly changes the WellID in its Well combobox, which
repopulates the subform, and it specifically requeries the report number
combobox in the AfterUpdate event of the WellID combobox.

At this point, however, on those problem machines, the date column of
the report number combo is blank and it doesn't show dates again until
the form is closed and reopened.  The combobox is being requeried,
because the correct report numbers do show up in it, but not the dates
associated with them.  The really odd part is that if you take the
formatting out of the combobox rowsource, the dates show up every time.


Has anyone else seen something like this?  I know I have, but it's been
years ago and I can't remember what caused it!

Charlotte Foust
Infostat Systems, Inc.



More information about the AccessD mailing list