I have a list box on a sub form. The criteria for the row source query of the list box is set to the value of another control on the sub form as follows:
The problem is that no values are being displayed in the list box when they should be. I have checked all the obvious. If I substitute the above for an actual value then it works fine. I have had this problem before but never been able to solve it - I have used the identical setup in other dbs and it has worked fine. I can only conclude it is some sort of bug.
I am using Access 2003 on XP Pro