[Filter] gives #Name? error

[BillNorton]

I'm afraid I'm a little rusty with Access, so this may be obvious.

I've got a form that has a text box that is intended to show the user what the filter is set to. I set the ControlSource to

="Filter: " & [Filter]

but all it returns is #Name?

I know it's worked before, so what's up?

 

[KeithG]

Try ="Filter: " & Me.Filter

 

[BillNorton]

Nope. That didn't work either.

OK. So now I've gone back several previous versions and they all had the same code and they all worked at one time. Could it be something about my installation?

 

[boblarson]

Um, are you just trying to display the filter? Then, it should be:

="Filter: " & [Filter]

 

[BillNorton]

Right. That's what I've got.

Something else is going on here, but I don't know what it is.

 

[boblarson]

You didn't by chance name the text box Filter did you? If so, change it.