Assign Default Filter In Access Form

[TGV]

Hi,

I am Having a TABLE with USER ID,. DATE, PROCESS STATUS, TYPE & PERSON NAME
like that, based on that I have created a FORM with USER ID, DATE & PROCESS
STATUS. USER ID is a TEXT BOX and the PROCESS STATUS is a COMBO BOX which is
assigned by way of Lookup Wizard. The PROCESS STATUS (Combo box) consist 3
options - OK, NOT OK & PENDING.

The form I have created is showing all the records that is OK, NOT OK &
PENDING Records. Here the form should show only the PENDING records. Whether
it is possible to apply any filter in the form to show only the PENDING
records and at the same time, if the users change the process status PENDING
to OK then the OK record should not be displayed in the form. The users
should be able to view only the PENDING records whether it is possible?

Please advice…

TGV

 

[Tom van Stiphout]

DATE and TYPE are reserved words and they should not be used as field
names. Change them now, and avoid future problems.

To apply a filter, set the form's Filter property to something like
[PROCESS STATUS] = "PENDING"
and set the form's FilterOn property to True.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

Hi,

I am Having a TABLE with USER ID,. DATE, PROCESS STATUS, TYPE & PERSON NAME
like that, based on that I have created a FORM with USER ID, DATE & PROCESS
STATUS. USER ID is a TEXT BOX and the PROCESS STATUS is a COMBO BOX which is
assigned by way of Lookup Wizard. The PROCESS STATUS (Combo box) consist 3
options - OK, NOT OK & PENDING.

The form I have created is showing all the records that is OK, NOT OK &
PENDING Records. Here the form should show only the PENDING records. Whether
it is possible to apply any filter in the form to show only the PENDING
records and at the same time, if the users change the process status PENDING
to OK then the OK record should not be displayed in the form. The users
should be able to view only the PENDING records whether it is possible?

Please advice…

TGV

Base the form... not on your Table... but on a Query with the numeric value
corresponding to "PENDING" in your lookup table as a criterion on [PROCESS
STATUS].

Note that the Lookup Field *conceals* the actual content of your table. The
table does not contain "PENDING" - it contains a number (I have no way to tell
what number), a link to the primary key of your lookup table.