Dr Watson on Combo Boxes in Access 97.

[longmot]

Hi, I seem to be getting a number of Dr Watson errors when using combo boxes. The database I have is has a split front end / back end.

The dr watson occurs as I go to select the from the combo box but before it shows any of the dates. It occurs every time you do this once it starts. If I refresh the database by deleting the Live version and copying accross the backup then it works again.

The row source code I am using is:
select distinct[ValueDate] from tblRBSLiq5AssetsALL ORDER BY ValueDate DESC

Any clues as to what may be causing this?

Thanks

 

[MazeWorX]

SELECT DISTINCT tblRBSLiq5AssetsALL.ValueDate, tblRBSLiq5AssetsALL.DESC from tblRBSLiq5AssetsALL ORDER BY tblRBSLiq5AssetsALL.DESC;


Assuming DESC is the name of a field in the underlying table being queried Remember amateurs built the ark - professionals built the Titanic