combo box

[jamccarley]

Is there any way to make the drop down arrow of a combo box invisible? I used
them to create a company section of my form where the user uses the first
drop down to select the company and all the other combo boxes bring up the
address, state, zip etc.... The only way I knew to link them was to use
combo boxes since there is a control source and a row source in the
properties box. I am sure there has to be another way, but this is the only
one I knew. I just don't like the arrows being visible. All except the main
combo are locked and disabled.

Josh

 

[Jeanette Cunningham]

Hi Josh,
you can use just one combo to do this.
Put all the fields in the one query.
Put as many columns as needed in the combo for selecting the company.
When the combo drops down, you can see all the fields for the selected
value.

To show those columns or fields you can use text boxes.
Set the control source of each textbox to the matching column of the combo.

example: =Me.NameOfCombo.Column(2) will show the info from the 3rd
column of the combo (the first column is column(0))
You could use one textbox for each column from the combo (except the bound
column which is usually hidden).

To hide the arrow on a combo, you can make a label or rectangle of the same
size to cover it and hide it.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia