Hi Everyone.
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.
Craig Allan
craigallansmith
0
Newbie Poster
Recommended Answers
Jump to PostUse the click event of the combo and set the text of the text box to the text of the combo box...
Text1.Text = Combo1.Text
Good Luck
Jump to PostOkay, you have an array so it would be...
Text1(Index).Text = Combo1.Text
Good Luck
All 6 Replies
vb5prgrmr
143
Posting Virtuoso
craigallansmith
0
Newbie Poster
vb5prgrmr
143
Posting Virtuoso
craigallansmith
0
Newbie Poster
vb5prgrmr
143
Posting Virtuoso
craigallansmith
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.