Is it possible to create more than one Value List

[tmdrake]

My form has a value list that contains four (4) options. I only want two of the four to appear int the combo box on this specific form. And the other two to appear in the combo box of another form in the same database. Is it possible to create more than one value list. If so, instruction on how would be greatly appreciated.

Toni

[Seth Schrock]

It is possible as long as they both aren't bound to the same field. Are the possible values determined by a previous selection, or are the possible values always going to be the same?

[tmdrake]

Thanks Seth, unfortunately I think they are bound to the same field, how do I separate them. Also, the possible values will always be the same

Toni

[Seth Schrock]

Well, let me clarify. Lets say that in form 1 you have the options A and B and in form 2 you have the options of C and D. You open form 1 and select A. You then close form 1 and open form 2 to the same record. That field will be blank because the value in it isn't available to the second combo box. You will be able to change the value to C or D. However, if you go back to form 1, that field will be blank because the value isn't available. Does that make sense? If that is acceptable, then you don't need to make any changes to the tables.

[tmdrake]

Seth, I think that's the problem, the options are not in a table, they are in the Edit List Items pop up box. I am trying to modify and add to a database that previously created by someone else. So would my best option be to create a table then bound the combo boxes to a different column in the table?

[Seth Schrock]

For this particular problem, it doesn't matter where the values come from (a value list or a table), but I would always recommend storing the values for combo boxes in a table.

So is your problem making it so that the possible values are different, or that when you make them different, the other form has the value blank? It might help if you told us the situation and what you are trying to attempt in terms of what the user sees, not as the developer.

[tmdrake]

Yes the problem is making them different for two forms. One form would show "NegativeTabWel d" and "PositiveTabWel d", and the other form would show "NegativePullTe st" and PositivePullTes t". Depending on which form the user is using there should only be two choices per form. Currently when the drop down arrow is selected they see all four options on both forms. I hope this is clear.

Thanks
Toni

[Seth Schrock]

Then you should be able to just remove the options from the list. I have never actually used Value Lists, but I don't think that the source of the data matters.

[zmbd]

If the control is not bound, then the record source is all that matters.... so the answer to your question is, in a nutshell, Yes it is possible to have mulitiple Listboxes using different rowsources (or even the same).
Please work your way thru the following tutorial:
>Create a list of choices by using a list box or combo box
(and as you didn't mention which version you are using:
>About creating a list box, combo box, or drop-down list box that looks up values)

These will answer 90% of your questions



And before you fall into this evil trap which creating list and comboboxes will eventually lead you to the dark side of ---- Lookup fields at table level ---

Using lookups at the table level lead to upsizing issues and can make VBA and Macro programing very difficult:
The Evils of Lookup Fields in Tables

There is one and only one reason to use lookup fields at the table level, when publishing to a share point site as linked tables are not supported directly.
If you are using linked tables and attempt to publish to a sharepoint site you will get: ACCWeb105016 Relationships that are not associated with a valid lookup field are incompatible with the Web.
In that case, and only in that case, create a lookup field between the related tables. Easist way is to wse the Lookup Wizard to create the lookup. http://office.microsoft.com/en-us/ac...BMaccweb105016