I use multiple text boxes on the form and then hide the columns in the combo box then after update I update the unbound text boxes on the form.
***Air code**
so if your combo box's row source was
select id,name,tel,add, city,st from tblcustomer then in the after update evet of the combo box you would do.
private sub cmbid after_update()
me.txtname = me.cmbid.column(1)
me.txttel = me.cmbid.column(2)
me.txtadd = me.cmbid.column(3)
me.txtcity = me.cmbid.column(4)
me.txtst = me.cmbid.column(5)
end sub
Just remember column lists in combo boxes are 0 based
HTH
Jag5x5
Main Topics
Browse All Topics
by: nico5038Posted on 2004-12-05 at 14:58:45ID: 12750168
Normally I offer my users a combobox with ID# and a (concatenated) name.
The ID# is hidden and the combobox is linked to a subform (in single form format) that will show the fields needed from the chosen name from the combo.
Idea ?
Nic;o)