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...
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...
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
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
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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)