ok I found the solution, but can someone explain why please

[1DMF]

Hi,

I was getting the following error..

Function isn't available in expressions in query expression.

i don't know why, the DB has been working fine all day, then suddenly that error started occuring.

I found the answer here...

http://support.microsoft.com/default.aspx?scid=kb;en-us;194374

My question is why did I need to select a reference to an object i didn't want then deselect it again for the DB to start working again.

What happened, and how does that fix it. I'm confused?

Cheers,

1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!

 

[RuralGuy]

It "refreshes" the references.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit