Here's the story:


I have 2 combo boxes.

cmb1 is based on a table and it lists our client names.

cmb2 is based on a table that lists the client type.

when choosing a client in cmb1 is there any way to make the default value of cmb2 auto populate?

there is a filed in the client table "type".

if it is already populated in the table, I want it to be displayed in cmb2. If there is no TYPE in the table, then the user should use cmb2 to select the type.

This is my story!

I am a complete novice to Access!

It seems that you have already done what I want to do, which is simmply insert a fully working combo box for the followiing purpose.
I have a form with commpany records,with the usual names ,addresses, tel no's e.t.c., but I want to CATEGORISE this data by what each company manufactures! The values in the COMBOBOX will be the products which are manufactured so COMPANY 1 may manufacture PHARMACEUTICALS, COMPANY 2 May manufacture FABRICS!
I want the combo box to display when tabbed PHARMACEUTICALS & FABRICS, I choose the one i want and then should i want to find only those companies which manufacture FABRICS at a later date, i can do this also?

Can you help?

Let's say your table has in this order: Client Name in column one and Client type in column two. On your form, name the Client name box as [Client Name] and name the client type bos as [Client Type]. Add the following code to the control source of the [Client type]box:

=[Client Name].[Column](1)

This will automatically display the client type in the box for you.