Question Searching datas from database after selecting value from COMBO BOX

[Noorul Ariff]

Friends i need code to search the datas...

I'm doing INVENTORY project...

i'm using ACCESS databse with vb.net...

i'm having purchase, sales tables...

THIS IS MY PURCHASE TABLE:


Code Price Category Type Dat SP Brnd
11 222 cde bgf 9/10/2025 356 asd
12 255 MEN Shirt 5/10/2010 355 Vanhesun
55 322 bb bb 9/10/2025 456 asd
66 422 bb bb 9/10/2025 556 fdd

when i select CODE in SALES form, corresponding values have to shown in respective fields...

I.e if i select 55, corresponding values 322 bb bb 9/10/2025 456 asd have to be retrieved and showed in respective fields...


Plz help me to finish the project...

Thanks in advance...