Vb 4.0 Problems updating Text Boxes from Combo Box linked to Data Control 
Author Message
 Vb 4.0 Problems updating Text Boxes from Combo Box linked to Data Control

My VB4 project has 1 DBCombo box (DBCombo.1), 5 text boxes (Text1 thru Text5),
and 1 Data Control (Data1).

My objective  is to  click on a selction in the DBCombo box (ie First Name (PGFirst))
and have all text boxes display the clicked on record from Access 2.0
(such that Text1 = PGFirst, Text2 = PGStreet, Text3 =PGCity, Text4 = PGState
and Text5 = PGZip.)

I placed the following code in the click event for the DBcombo box:

        Data1.Recordset.FindFirst "[PGFirst]" = """ & DBCombo1.Text & """

Problem: The Data Control is working fine with all 5 Text boxes and scrolls
back and forth through the data, but when I click on a record in the
DBCombo box, the first name is displayed in the first Text box (great!)
but the other text boxes remain on the last record and do not change
to reflect the current record (Ugh!)

Any ideas are greatly appreciated!

Thanks,

Phil



Mon, 20 Jul 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Rich Text Box Control (RTF) - VB 4.0 Update?

2. Rich Text Box Control (RTF) - VB 4.0 Update?

3. Rich Text Box Control (RTF) - VB 4.0 Update?

4. How do you update text box from combo box

5. Linking VB text box to powerpoint text box

6. Filling combo box text box area from data

7. Linking Combo Boxes and Data Controls

8. Problems making a automatic text box when selecting in a combo box

9. Please help: Data in array of combo boxes must scroll with DBGrid (VB 4.0 16-bit)

10. enter data in a combo box based on value from another combo box

11. using VB text boxes data but not text boxes in word 2000

12. Passing Data from VB App Text Box to a Web Page Text Box

 

 
Powered by phpBB® Forum Software