Hello! First post at these forums.
I'm trying to open a Report and filter it's record source. I've had success with the following:
Code:
SELECT *
FROM TestTable
WHERE (((TestTable.[Column]) = True));
These achieves most of my goal, filtering the source to where the column named "Column" is checked.
My hope is to change this so it will find the column's name from a text box in a form. I want to do this so I can dynamically select which column the filtering is based on rather than having to go in and manually change it.
This doesn't work, but I'm thinking something along the lines of:
Code:
SELECT *
FROM TestTable
WHERE (((TestTable.[Forms!TestForm!Textbox.Text]) = True));
Does this make sense? I image it is possible in some way or another, however I'm pretty unfamiliar with Access syntax.
Thanks!
-Tim