Limit Dropdown

[scott04]

Hi everyone, I have a field on a form called Status which is simply the
status of the record. There are 3 different status a record could be for the
form : "Pending, WIP, and Completed" that all come from my table, tbl_status.
I was thinking of creating another form to be used after Management reviews
the completed work and in doing such add another status called something like
"Complete Mgmt Review". Is it possible to have the first form only load the
first three status: Pending, WIP, and Completed while having my other form
load 4 status? Thanks

 

[Ron2006]

Two ways:

1) On the first one where you want only the three you could make a
query to be the source of the information and have criteria saying
<> "Complete Mgmt Review"
and on the second dropdown do not place the criteria.


2) Add a field to the status table (maybe a check box) and decide on
a marking scheme - Say make it true if it is to be part of regular
status dropdown.
And then add criteria to the query for the first dropdown to match
what ever scheme you decide on.



Ron

 

[Ryan]

There are several ways to do this, but the easiest would be to to add another
column in your tbl_status table called showmgr with a datatype of yes,no.
Then on the form for non-management, in the recordsource of the combobox, add
the showmgr column and set its criteria to false. Then go to the table and
only check the box for "Complete Mgmt Review". That will prevent it from
being seen on the non management form.

 

[scott04]

Thanks Ron and Ryan you both answered my question and i appreciate it.