Combo Search Rowsource

[Milothicus]

I'm setting up a search form for my database. On my input form, i have a combo that's populated with a value list. I want to use the same value list for a combo on my search form. I copied the values from one value list to the other, but if i update one, i want the other to update automatically.

Can i set the search combo to use the input combo's value list? How would I reference a value list for a field in a table? On the other hand, would it be a better idea to remove the value list and put the values in a table?

 

[Mile-O]

If your Value List will never change (i.e. "Male";"Female") then it's a good idea to keep it as a Value List

If, however, your value list is prone to change then it is best to keep the info in a table and use a query based on the table as the RowSource.

 

[Milothicus]

Pretty much what i thought.

I just know for the first while, during the 'testing' phase, the options i need will likely change, but not very often. is it possible to have one value list take its values from another?