Binding multiple columns in a combobox
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Here is a scenario I have a bound combobox with two columns Column(0), and Column(1) both visible. I want to search the combobox based on either value of both columns. In the words if Isearch ID it will lookup the value and if I search by name it will also lookup names.
Is there a sample VB script in the after update event of combo box that will accomplish that?
If I give this comboBox a value eg Me.cbo.value = "Text" it does not show up. I assume this is because it is adding it to the first column. But because "Text" is not in the list of items in the combobox there is nothing to show for the second column.
Thus is there a way to add a value directly to the second column which is not in the list of values for the comboBox.
How do I get multiple fields to come out in the second combobox? Is there a way to add multiple fields to RowSource or do I need to do this differently?
In Access I'm having a table "XYZ". This has 2 Columns "X" and "Y". In Access, I've assigned the "Display Control" tag (Open any Access Table->Go o to "Design View"-> Go to "Lookup" tab) as "Combobox" for Column "X" and as "TextBox" for Column "Y".
Is there a way that I can query this property in my C# code? i.e.
dc = DataTable.Columns;
if (dc.<To Figure Out>.ComboBox
How do I get the selected data in the combobox to appear in the same order on the table as selected and not in alphabetical order? I think it may have something to do with the criteria section of the query that generates the combobox from the source table!
This means a particular fish can contain 1+ genes at a given time. I have separated these genes into 4 columns for easy tracking. The problem is when it comes to building a search form.
A particular gene can be in one of the 4 columns. So I need to search for that gene in all 4 columns. There are also multiple genes to search so I will need to search all 4 columns based on how many genes there are.
genes contain a key so my original plan was to transfer keys to 1 new column and run
like "*#*" AND like "*#*"
to find the genes of interest.
1 | 7 | 13
2 | 8 | 14
3 | 9 | 15
4 | 10 | 16
5 | 11 | 17
6 | 12 | 18
The reason is this is a single checklist for people to fill out and multiple pages is unacceptable. The list will be printed.
This Combobox lists 5 columns; ID, DuroLow, DuroHigh, PostLow, and PostHigh (these names are shortened here)
On the form there are 2 fields where data can be input that must be validated as being between the appropriate highs and lows.