!! HELP !!

[Joshua]

I'm new to visual basics and I'm workin on a little project to help me
learn. I'm sort of stuck on what i'm sure most of you would consider an
easy problem. If someone could kind of point me in the right direction i
would be forever in their debt.

First off i'm using VB 6.0 to make a database frontend for a MS Access 2000
database(ADO). The problem i'm having is more of ignorance in the way of
programming techniques then anything else.

I have a table that will call "tblOrders" which is accessed through a form
called "frmOrders" I also have a table called "tblClients" which is
accessed through the same form, frmOrders.

My problem is:

When i pull down a drop down box on the form to select a client to add to
the "tblOrders" table how can i make the clients information...such as
address and what not, populate the fields that binded to the "tblClient"
table?

the two table are joined by the "client ID" field

I'm using a data environment to connect to the database and thats working
great. Both the record sets can be retrieved from the form. I just dont
know what method you can use to make the correct client come up with the
order.

I know, i suck - but i'm new!

If anyone one can help without making fun of me that would be great!!!!!

jos...@joshuaz.com

[Ana Maria Anzulovich]

In after update (in the list box) you set the text fields for the address
and all you want to be read from the same source of the list box, making
visible true.
Good luck
Ana
Joshua <jos...@joshuaz.com> wrote in message
news:zcU85.512$D76....@news.pacbell.net...