April 23rd, 2003, 11:47 AM
ComboBox Item Populating a Form
I pls need a help, may be a sample code or something on, I want to be able to search a user with a user code, get a form populate if the user exist in the Database, but at the same time in one corner of the form I want to be able to see the list of other user's code in a ComboBox from the Database, and onclicking on any user code in the ComboBox the same form should be populated with the user' information.
Right now I have a functional Application but without the ComboBox functionality.
April 25th, 2003, 08:22 AM
Try this out may be this can help u
open the connection here
run you quary
get the value of the query in the record set
<select name="tl" size="1">
On Error Resume Next
do while Not rs.eof
<option value="<%=Server.HTMLEncode(rs.Fields("UserID").Value)%>"><%=Server.HTMLEncode(rs.Fields("UserID").V alue)%></option>
where rs is recordset name and UserID the IDname in your table
try this out I hope u will be able to do the job you want
Small things lead to perfection and perfection is not a small thing.