Disable filter within one column on Access form -datasheetview

[jaryszek]

Hi Guys,

it is possible to disable filter on open form?

I am using button and cocmd.open form with specific criteria, here login.

So if user has login "ljar01" then form will shows only his records (with login "ljar01").
I want to show the users only filtered records.

And second condition. There is a user group where they shoud see each others records.

So for user ljar01, pzie00 and mras05 there should be only records with these usernames.

And my dream is to have possibility to filter 2 or 3 criteria on datasheet view form, disable possibility for filtering within Login column only and rest columns should have possibility to filter.



please help Guys,
Best Wishes,
Jacek

[ranman256]

when the user opens the db, there should be an invisible text box to hold the userID when the form opens:

txtUserID = Environ("Username")
me.filter = "[loginID]='" & txtUserID & "'"
me.filterOn = true

turn off the filter with:
me.filterOn = false

BUT, if you want the user to see only specific group of Logins, then you must have a table to hold the list.
then the query that shows the data would join to this ....

select * from tData, tUsers2See where tData.UserID = tUsers2See.UserID and tUsers2See.GroupID = forms!myForm!txtUserID

[jaryszek]

thank you ranman256!

I know your solution. And it is okey but i want to disable possibility to choose another filter (so here is ljar01 but still able to choose another login):



Maybe here i should use recordset only ?

Best Wishes,
Jacek

[ranman256]

set the form property ALLOWFILTERS = FALSE

[jaryszek]

thank you !

It is possible to allowfiltering set as false only to one column?

Best Wishes,
Jacek

[ranman256]

no...the entire dataset filters, not 1 column.
but you can filter ON 1 column if filtering is allowed.