Selasa, 08 Mei 2012

[AccessDevelopers] Adding Regional Filtering on All Forms

 

Hello all,
I have a database that I have been using for a while here in the EU and our US counterparts would like to start using it. They would have almost 100% their own data other than some tables.

My plan is to create a new landing page that allows you to select the region that you are coming from. Then when each form loads it will only show records for your region. Also when you write a new record it will tag it with what your selection was.

I know that I can filter a form using the properties tab by setting the "Filter On Load" to Yes and putting something like region = 'eu' in the filter field.

Now for the question... Is it possible to set that filter value to a Global variable value? Anyone have any experience with doing something like this? Is there a better methodology then the path that I am heading down?

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar