Conditional Value List (global) from all record data in field

[bcolburn]

I know this has already been answered on here, but the conditional value list threads I keep findings seem to be asking slightly different questions from what I am after.

I have a field of interest [status] on a table called "Checklist" with many possible responses in its value list. I am ultimately trying to create a running list that shows the last names on each record where [status] is any value other than "Complete" (others include "Need to request", "In Progress", etc.")

I decided to create a second field [status Incomplete] on the same table ("Checklist") with a single value (*Yes") so I can perform a much simpler find for all records where [status Incomplete = "Yes"]. I am ultimately trying to create a globally stored conditional value list on a separate layout that creates a constantly updated conditional value list based on the response to [status Incomplete]. I am also trying to create a running count of how many values are on that list so I know how many records in the entire database are still incomplete. I realize that second part is not related to conditional value lists, but I fear I may run into trouble with the count function there using the little I know about it so far.

I'm totally lost. Can somebody please help me??? AHH!

*breathe*. Thanks!

[doughemi]

Did you look at the sample file I posted in your other thread on this subject?

Multiple threads make it real hard for people to help.

[bcolburn]

Right. But this is a slightly different question. I'm asking about creating a conditional value list. And I asked again about the running count because I was afraid that if I was calculating counts based off of the conditional value list (number of values present) then I might get into trouble. I'm not ignorant or ignoring you. I just realized I might need to go in a different direction and asked for a help.

[comment]

I almost thought I understood what you wanted - until I ran into terms like:

I am ultimately trying to create a running list

I am ultimately trying to create a globally stored conditional value list

You are dealing with a technical issue here; you can't just invent your own vocabulary.

[comment]

Anyway, have a ;look at the attached.

IncompleteValues.zip

[bcolburn]

You're totally right. Thank you for helping me clarify my language. What I meant is that I want a list that creates a value list in realtime base don data drawn from another field. I want it to display the same result on all records in the database. So basically, I want it to find all records where a field of interest has a particular response (e.g. data not yet collected) and then display another field that identifies that record (e.g. last name) in list form on a layout that can be accessed from all records. Is that clearer? I'm trying! :)

[doughemi]

I THINK this sample does what you are asking. If not, please advise which part of it does not.

DisplayStatus.fp7.zip