Basically I have a form where user selects field for the report to be based on, and it displays a fixed set of fields + the one they select of all the records.

I would like to filter out the records if the selected field is null. Normally this would be easy [myField IS NOT NULL] but since the textbox gets assigned its field programmatically, I'm having trouble.

I think it has to be something like [myTextbox].ControlSource IS NOT Null, but I don't know the proper syntax or way to do this. Any ideas?