I am busy building a VB 6 APP that will access a MS Access database. For the sake of this problem I will abreviate the DB. It has two tables. the main table has 6 bound text boxes to a data control. They work fine on there own. My issue is that I have added a drop down combo which accesses the other table in MS Access. I populate the drop down using a command button on the form with the textboxes using the additem for the combo and rs.fields.value to populate the combobox. I want users only to be able to select an item from the combo which must populate the one textbox and then they can fill in the rest of the fields normally. I am new at using VB to create a frontend for a DB as I normally use VB for excel manipulation so I am struggling to figure this out. I cannot find any help in my documentation so hopefully someone can point me in the right direction.
Thanks in advance for taking the time.