Creating data entry form

[ksukat]

Have the following tables:
Client
client_num text
client_name text
client_addr1 text


client_addr2 text

Jobs
client_no text
job_num text
job_start date
job_stop date
tot_hrs decimal

I have created a form with its data source of Jobs.
I have put a combo box on the form for the user to choose the client_num. I want the combo box filled with client_nums from the client table. when the user selects a client_num, I want a text box on the form to show the client_name.

I have googled and tried a thousand things. None have worked. I know this has to be simple, so ... what is the right way to do this ?

[pbaldy]

A thousand?

Make sure the name field is included in the row source of the combo, and have this as the control source of the textbox:

=ComboName.Column(x)

where x is the column containing the name (note the column property is zero based, so the second column is 1).

[ksukat]

Well, maybe 5 or 6. When frustrated that equals 1000.

BTW, elegant and it worked. Thanks!

[pbaldy]

No problemo, and welcome to the site by the way!