Continuous form change parameter/criteria

[Ruegen]

I have a continuous form with two buttons.

I need the buttons to change the records to show a field with the criteria Is Null and then Is not null



I'm wondering how to do this with vba...

[June7]

Won't work with continuous form. If you change the textbox Visible property it will be applied to ALL instances of the control. However, can use Conditional Formatting to Enable/Disable control.

[Ruegen]

Yeah that's fine, basically I want to show all​ the records that have a field filled and then all those who don't.

Then requery the form just after whatever vba

[June7]

Then you want to filter the form recordset, not 'show a field'. More than one way to accomplish. Maybe simplest is to set the form Filter property. Like

Filter = "[fieldname] Is Null"
FilterOn = True

or

Filter = "Not [fieldname] Is Null"
FilterOn = True

[Ruegen]

the criteria of the column already has show/select "is null" only

will the filter change that criteria?

(asking only because I am trying to understand etc)