[AccessD] AXP Combobox Shows blank formatted date column

Hi Charlotte

I would try up to four things until success:

1. Replace the format string with "dd\-mmm\-yy"

2. Adjust the query using Group By.

3. Save the query as a stored query and use this.

4. Replace [Forms]![frmDailyRpt]![cboWellID] with a function
GetSelectedWellID() which retrieves the WellID but returns a Long as I
guess your ID is.

/gustav

>>> cfoust at infostatsystems.com 03-03-2005 20:03:45 >>>
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.