Hi,
I have a small problem, and if you know the answer I would really be
thankful for your help.
I have an access database which is called "Client.mdb"
on a form, I displayed a dbcombox for the costumer's name
a textbox for the address
a textbox for the city
a textbox for the state
and a textbox for the zipcode
on all my textboxes and the dbcombobox I have set their Datasource and
Datafield properties to Data1,
when I run the program the information on the first record of the data shows
on the form,
but what I need to do is, when I change the costumer's name on the
dbcombobox (which displays all of the costumer's names on it) I want the
textboxes to show the address, city, state, and zipcode of the costumer I
have choosen,
Thank you in advance,
Enrique G Lugo

What you have to do now is to synch your textboxes with what is in the
data1.index...
So what ever the index # is then the text1.text should be = to that
field.index

If this doesn't help, I might have a vb4 routine that I could e-mail
you.

There should be some Data properties on your text and combo boxes which can
automatically update those controls with the record selected.
--
Ryan Faricy
RySoft

VB5 Site: http://ourworld.compuserve.com/homepages/rfaricy/index.html

The world keeps ending but new people too dumb to
it keep showing up as if the fun's just started.

John Updike - Rabbit is Rich