AHHH... I did say I was a newbie =] ...one more question, how do you
translate the ! that is used after RecordSet?
Label1.Caption = Data1.Recordset!Name
I do appreciate your time!
> You can use the Combo1_Change() event.
> Private Sub Combo1_Change
> Label1.Caption = Data1.Recordset!Name
> Label2.Caption = Data1.Recordset!Address
> End Sub
> When you change the row in the combo, you also change the row in the
> database so each column ID, Name, and Address are the current record.
> You could also link each label to the data control and field in the
> properties window.
> Label1.DataSource = Data1
> Label1.DataField = Name
> > I am new to VB and I am trying to develop a simple program:
> > I have an access database called Client with a table called client
> > that has 3 rows ID, NAME, and ADDRESS.
> > My VB project has a simple form that contains 2 labels, and an ADO
> > box. I have the datacombo linked to the ID and I now want my labels to
> > change to the appropriate name and address when I change the ID.
> > I seem to have run into a stand still..I can not get the labels to
> > change/update when I select a different ID.. is there an after update
> > should I be using a on change event?? I really have exhausted all my
> > so I must ask for assistance.. an example would by the ultimate or
> > direction..show me the way
> > pete