2 Column Combo Boxes in display.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
When adding a combo box to a field in a table, is it possible to restrict the values so that they include only a subset of the entries in the relevant column from the source table?
For example, Column A in Table 1 might contain a list of names, while Column B contains check boxes to state whether the people named are still alive. Column A in Table 2 might then contain combo boxes linking to Column A in Table 1. Would it be possible to restrict the values in the combo boxes so that they contained only names of people who were still alive
My combo box "Product" is taken for a table which contain 3 fields: FLD1, FLD2, FLD3. so, if you click on the combo box you see the first record. Now, being that these records are very long, I want the user to be able to see in on the Form, because they cause see it on the combo box!
So, I want to take the Combo FLD1 and store the data and make a text box to display the test in it and do the same for the other two fields.
So, as the users click on the combo box the wording would also display on the form in three different text boxes. How do I store that information in the Combo Box to be displayed on the current Form in three separate text boxes.
Is there a way that I can get names from this list to display in a combo box, but make sure the ones that have the Yes/No box checked to be hidden?
So far I've been able to list the names in a combo box from a single column,
list the names in a combo box from multiple columns,
list the names in a combo box from a single column and hiding some of the options by using a query,
But when I try to list the names from all columns, it doesn't do what I want.
What should I do? I'm kinda
So I have one combo box called "TreatmentStage" based on a table: Column 1 Column 2
When the "TreatmentStage" box reads, for example, "E1" I would like to disable combo boxes numbers 43, 46, and 50. (Or if not to disable, then to set these combo boxes to "sample_not_taken".)
I have a lookup column that works fine, but when I try to get the value through vba, I can only get the bound value (a number). I tried doing it the way I would for a combo box: [field].Column(1), but that didn't work. I need the display value so I can use it in a Dlookup function on another table