i have 2 tables in excel
first table: table students: id, last name, first name address , etc. table two: notes on students: each student can have records,i have 2 columns of table. student id , comments table want fill out form
form combo box students , text box entering notes, add button add records
wanted combo box appear name of student (last name+first name) , when click add, code put id student's of selected student
i thought combo box can set each row: text , value, text view , value not
as in asp.net
dropdownlist.datatextfield = name dropdownlist.datavaluefield = id
now see text can set
wrong , can not known, , if not how can solve problem
you have declare 2 combo box
1 names , second rhe id
id's combo box there disables
order of 2 combobox listed order in appears in table
id of selected student:
cbxid.list(cbxnames.listindex)
Comments
Post a Comment