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?
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?
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.
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.
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.
Currently, the combobox relies on a separate table that populates its values (a lookup table more or less), but each field in the separate table does have a corresponding field in my main table.
I did the =column5(or whatever column) and got it to display the correct info for each column field in the form, but that doesn't affect the underlying table.
How can I make it so I have multiple tables that would work the same way. For example a Product Type (table)>Product (table)>Colors (table). So all independent tables, but making showup in cascade like they would if I had them in one table with the method I'm using now.
Form A is a waiting list of people who want to attend one of our several courses.
Form B is a bookings form where the operator selects a course from a list, a person's name from a combobox then clicks a button to make the booking.
I'm trying to make things easier for the operators by allowing them to highlight the entry for person X in form A, then click a button on form A that opens form B and writes SQL code (whichcontains a where statement that identifies the ID number of person X) to the recordsource property of the combobox.
The code then requeries the combobox to populate the rest of the columns and other controls on form B.
The problem is the combobox on form B doesn't seem to requery. I'm writing to the bound column but after .requery the columns contain nulls, but if I click the combo box it drops down toshows only one person correctly identified by the ID value I've written to it.
I can write values to text boxes on form B easily from one form to another, but the combobox has 16 columns (don't ask) so I don't want to go down the route of adding many extra hidden text boxes to form B.
Forms!bookcourses!cmbFindDelegate.RowSource = strSQL1 & strSQL2
The 6 bound fields are within a custom made "option group" so that users can select the related permit(s) via check boxes. I understand this is a poor design because of multiple fields in the table but it looks good on the form and each record can have multiple permits.
What I would like, is to use an unbound combobox within frm_Search, Cbo_Permit, using the names of the fields I shown above. The user then selects a permit within the combobox and presses acommand button to open frm_Form1 filtered to that particular permit.