Combobox selection to move to database Record/fields

[data59]

I have a ComboBox, (unbound) that has several items listed, My form is linked to a Access Database. If the combobox matches an entry in a field(ID) in my combobox, I want to be able to move to that record in my database and display the other fields information in textboxes. Easy to do in Access but I can’t figure it out in VB6

 

[dglienna]

Something like this should do it. I use something like it to query a table based on the field that is selected in the combo.

combobox.additem "sales person",0
combobox.additem "Customer Name",1
on the search button
add this code
select case combo1.listindex
case 0
rs.Open "Select * from INVTB1 WHERE SP='ANUP' Order By CN", db, adOpenDynamic, adLockOptimistic
case 1
rs.Open "Select * from INVTB1 where CN like '" & Text35 & "%'", db
end select

-David
2006 Microsoft Valueable Professional (MVP)
2006 Dell Certified System Professional (CSP)