hello,
i am doing a project on mobile store in vb6.
i have a mobile store.mdb access(2007) database.
The layout for the form is given below..



The database has tables like...APPLE,BLACKBERRY,NOKIA,HTC etc.
every table has fields..Model_Number,Type,Platform etc.

when i select the table name from the combobox (like APPLE in the screenshot). The listbox displays the Model_Number field in APPLE table...along with the pic. in the frame.
The problem is...i want that when the user clicks the item say "iPhone 4 16 GB" , the 3 textboxes below the frame should display the Model Number,Type and platform for the selected item in listbox into the corressponding textbox.

Plz help..it's urgent