I have a form with 6 combo boxes. All the combo boxes will change rowsource value depending on what value is in the first box, which is a number field, so always a number. I used the code builder to do this:
Private Sub Form_Current()
If Me.Cabin.Value < 10 Then
Me.Skill_1.RowSource =...
How can I change the value of a combo box on exit. I want it to switch from ID to Name. This we I can input id (faster) and it can then show be name.
Also, I would need to be able to choose Ids from the drop down as well, for future changes
How can I update a combo box on my form to show one of two tables, depending on what number the user enters for the first field (integer)
So something like an IF statement for the combo box:
If number field <10, show lower table in combo box.
If number field >10, show upper table in combo box...
I have a form where I have a lookup field. It comes from a table with two fields, Name_ID and Name. The lookup is set to show me the name ID. How can I get the Name to be displayed on the table though? Thanks!