I have a combo box on a form which is based on table tblMachine. On that
combo box I have four columns visible MachineNumber, description, location
and type. The bound column is the MachineNumber and this is not set to 0 as
the machines have its number on which means the user should know the machine
number. My problem is if the user doesn't know the number. I have a button
which changes the row source of the combo box to order by description, but
when the user starts to type the description the relevant record does not
come up as machine number is still visible. Is it possible, when I change
the row source to also make the first column width 0 through code?
I also want to enable the user to search the combo box leaving the drop down
filled with the search results.
I also have an unbound textbox for the user to enter their search terms, but
I am not sure of the next step
Thanks in advance