T
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 in design view with USER ID,
DATE & PROCESS STATUS. USER ID is a TEXT BOX and i have assigned primary key
for User Id.
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 i want to set a default autofilter to filter the
PROCESS STATUS with PENDING records only. 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 from
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
I am Having a TABLE with USER ID,. DATE, PROCESS STATUS, TYPE & PERSON NAME
like that, based on that I have created a FORM in design view with USER ID,
DATE & PROCESS STATUS. USER ID is a TEXT BOX and i have assigned primary key
for User Id.
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 i want to set a default autofilter to filter the
PROCESS STATUS with PENDING records only. 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 from
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