Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box on a form that pulls information from a query and I want the rest of the information which comes from this query to be fille din automatically in the remaining text boxes. How can I do this.
 
-----Original Message-----
I have a combo box on a form that pulls information from
Click to expand...
a query and I want the rest of the information which comes
from this query to be fille din automatically in the
remaining text boxes. How can I do this.
.
make the query of the combo box have all the fields you
Click to expand...
want in the text boxes. Show only the main field in your
combo box to the user. Then make the control source of the
text boxes = me.cboComboName.column(#). The combo box
columns start at ZERO and then increment from there.
 
-----Original Message-----
is setting the control source =me.comboname.column(#) correct. I get errors.
.
Click to expand...

You have to replace comboname with the name of the combo
box you are using and the # with the number of the column
you want to use in the text box. Lets say you have a combo
box "cboName" based on a query with three fields. the
first field is last name, the second is First name and the
third is middle inital. You want the user to select the
last name from the combo box but the first name and middle
initial will just show in text boxes. the combo box must
have the number of columns set to three and you need to
select the three fields (mentioned above) from the query
in the order from left to right. You will want to have
column 1 bound in the combo box. Now set the first name
text box =me.cboName.column(1) since when refering to the
combobox from a text box you must start with ZERO instead
of ONE. that will populate the text box with the first
name. Then you set the next text box =me.cboName.column(2)
to get the middle initial. Hope this helps.
 
Back
Top