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.