Value List Based on Found Record Set?

[MattFM]

Hi.

I can't find out how to do this, but I have a value list that is used in a Drop Down menu. The value list is populated by a "Name" field. So, every Name from every record is in the Value List and Drop Down menu.

What I want is to have the Drop Down Menu display only the Names from the current found set of records, instead of all records all the time. Is this possible, and if so how is it done?

Thanks for any help.

[bcooney]

I think you're going in a bad direction. First thing that struck me is that you're storing Names not IDs. I assume that this Name field is a key? Stick with IDs for keys. Create your value list from two fields, the ID and Name from your source table.

As for limiting the choices in a value list, search for "conditional" value lists.

[MattFM]

There are IDs in there too... here's a really basic example of what I mean...

names_list.zip

[bcooney]

Take a look at this demo.

names_list_2.zip