filter DB table from Front end

[A S MANN]

filter DB table : I have a front end database through which I reach to back end tables. Is any code is available to filter the data available to front end DB as per filrer criteria.
User should select a filer field data at his login form. then all the data available to front end ( Query, form reports etc) Must be filter as per filer field data ( Say financial Year)
Is any sample DB available as example
Thanks in advance.

[NTC]

My interpretation of your post is that you seek user specific data control. Although you mention it being date based - so it is less clear to me what you seek.

Can one make an FE that only sees current year data or year X data - sure - in every relevant query you must put a year value criteria.

Generically speaking it is user specific controls that is sought: This would be implemented via a login method, with an underlying login table; a range of permission IDs....and those IDs implemented at the record level. You then enter the ID (possibly user initials or a 'class' they belong to i.e. sales) into a field in the records themselves as they are made - - and then use queries to filter what is presented depending on the user.

There is no pre-canned solution that meets the variety of needs.

Hope this helps.

[A S MANN]

I am looking for a Year date filter which will filter the back end data tables as per year value selected at a login form
I had tried to give a temp variable as year field selected at login form
the same temp variable than filter the data as per selected value of year
The no of query, forms and reports are many and this is very time consuming work to filter each one by one with temp var.
so i through if a vb code can filter the back end that will be the best for my design. any way thanks.