Using ColumnHistory

[CSAngel]

Hi. I'm trying to get the column history for a field using the
Application.ColumnHistory function, however, I get an error when the function
is called:
Method 'ColumnHistory' of object '_Application' failed

This is my call:
history = Application.ColumnHistory("Risk Table", "Latest Action", "[ID]=6")

I've double checked the table and field names - they're correct.

Thanks.

 

[Gina Whipp]

CSAngel,

Without seeing the rest of the code try:

history = Application.ColumnHistory("Risk Table", "Latest Action", "[ID]= "
& 6)

I am also assuming you are using Access 2007, since I THINK this is new to
2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm