I'm very new to VB and I'm trying to do something which I thought would be very easy.

I have a drop down that is populated with some names from a database. Upon selecting a name from the drop down I'd like the other fields to be populated with the rest of the data from that row.

What's the easiest way to go about this? I've only been able to get it to pull the data from the first row of the DB and nothing else.