B
Brian Smither
I have a form that was filtering just fine. I do not know what I did, but
now the Filter option on the context menu is greyed out.
There was a few hours where I had decided to disable the Filter action
and so I set Allow Filters to No on the form's property sheet. A while
later I decided that, yes, I do want to allow filtering. So, I set it
back to Yes.
But the context menu still has the Filter group greyed-out.
Access 2003 - everything is unbound. The form_open() connects to SQL
Server 2005 and populates the fields. Just to be sure, I also have:
Me.AllowFilters = True
Me.FilterOn = True
The recordset is:
..CursorType = adOpenKeyset
..CursorLocation = adUseClient
..LockType = adLockBatchOptimistic
Also on the form's property sheet, there is Recordset Type of Dynaset and
Record Locks at No Locks. Is there a conflict here?
Is there some other condition(s) that is not obvious that would keep the
Filter group disabled?
now the Filter option on the context menu is greyed out.
There was a few hours where I had decided to disable the Filter action
and so I set Allow Filters to No on the form's property sheet. A while
later I decided that, yes, I do want to allow filtering. So, I set it
back to Yes.
But the context menu still has the Filter group greyed-out.
Access 2003 - everything is unbound. The form_open() connects to SQL
Server 2005 and populates the fields. Just to be sure, I also have:
Me.AllowFilters = True
Me.FilterOn = True
The recordset is:
..CursorType = adOpenKeyset
..CursorLocation = adUseClient
..LockType = adLockBatchOptimistic
Also on the form's property sheet, there is Recordset Type of Dynaset and
Record Locks at No Locks. Is there a conflict here?
Is there some other condition(s) that is not obvious that would keep the
Filter group disabled?