K
Kahuna
Hi Folks as a follow up from the help I got yesterday regarding the proper
opening of the ComboBox:
Ahh - thanks for help guys but it seems there is another part to my
challenge.
I have the combo loading successfully now (thanks Marshall), but I am
loading
other text box's based on the other columns in the rowsorce for the combo -
so eg:
=[cboMatTypeDesc].[Column](5) loads the text field with data from column 5
of the combo (or 6 in fact as its 0 based) rowsource (or should).
However this is working sporadically. I have 35 or so fields being populated
in this way and many of them are simply not being read / populated from the
look-up table.
Is there a limit on how many columns there can be in the rowsource for the
combo (I am only displaying 10 - though not consecutively listed).
Is there a more elegant way to do this - I suspect DLookup would be clumsy
and time consuming during run, and there is the challenge of what to do when
there is no entry on the ComboBox - Dlookup inserts an Error?
Any suggestions ?
opening of the ComboBox:
Ahh - thanks for help guys but it seems there is another part to my
challenge.
I have the combo loading successfully now (thanks Marshall), but I am
loading
other text box's based on the other columns in the rowsorce for the combo -
so eg:
=[cboMatTypeDesc].[Column](5) loads the text field with data from column 5
of the combo (or 6 in fact as its 0 based) rowsource (or should).
However this is working sporadically. I have 35 or so fields being populated
in this way and many of them are simply not being read / populated from the
look-up table.
Is there a limit on how many columns there can be in the rowsource for the
combo (I am only displaying 10 - though not consecutively listed).
Is there a more elegant way to do this - I suspect DLookup would be clumsy
and time consuming during run, and there is the challenge of what to do when
there is no entry on the ComboBox - Dlookup inserts an Error?
Any suggestions ?