(Again) dependent fields,

[jamal numan]

(Again) dependent fields,

In the attached screenshot, I wanted to choose the values of the fields of the table from other two tables

I applied the combo box tool to read the values of the first field from a list but couldn’t know how to achieve the following:

1. If the value A is chosen in the field T07_F1, then the values on the T07_F2 should be A1, A2 or A3

1. If the value B is chosen in the field T07_F1, then the values on the T07_F2 should be B1, B2 or B3

1. If the value C is chosen in the field T07_F1, then the values on the T07_F2 should be C1, C2 or C3

The mdb file is attached

And so forth.

Which code might achieve this sort of things?

Thank you for the help,

Best

Jamal

[June7]

You are saving the numeric ID values in T07, not the alpha characters. This actually complicates. Dependent comboboxes with 'lookup' RowSource in Continuous or Datasheet view do not work nice. Review https://www.accessforums.net/queries...nly-29163.html

Also, you are doing this in a query, not on form. Dependent comboboxes have to be on a form because a little code is involved (unless a Data Macro can run the code). Review http://datapigtechnologies.com/flash...combobox2.html

If you saved the alpha values, the T07_F2 combobox RowSource would simply be:
SELECT M_English FROM T07_F2 WHERE M_English LIKE [comboboxname] & "*";

[jamal numan]

You are saving the numeric ID values in T07, not the alpha characters. This actually complicates. Dependent comboboxes with 'lookup' RowSource in Continuous or Datasheet view do not work nice. Review https://www.accessforums.net/queries...nly-29163.html

Also, you are doing this in a query, not on form. Dependent comboboxes have to be on a form because a little code is involved (unless a Data Macro can run the code). Review http://datapigtechnologies.com/flash...combobox2.html

If you saved the alpha values, the T07_F2 combobox RowSource would simply be:
SELECT M_English FROM T07_F2 WHERE M_English LIKE [comboboxname] & "*";

Thank you for the valuable answer.

What if I include the values of the T07_F1 in the T07_F2? Does this simplify the issue?

The screenshot and mdb are attached

[June7]

If you want to do queries that join these tables then save T07_F1 pk value in T07_F2. However, that is not necessary for these dependent comboboxes to work, if the data you show in tables is actually what you will be working with.

If the primary combobox has the English value in column 2 and the BoundColumn is set to column 1 then the dependent combobox must reference column 2 as criteria. Column index begins with 0 so column 2 is index 1.

SELECT V_English FROM T07_F2 WHERE V_English LIKE [comboboxname].Column(1) & "*";

[jamal numan]

If you want to do queries that join these tables then save T07_F1 pk value in T07_F2. However, that is not necessary for these dependent comboboxes to work, if the data you show in tables is actually what you will be working with.

If the primary combobox has the English value in column 2 and the BoundColumn is set to column 1 then the dependent combobox must reference column 2 as criteria. Column index begins with 0 so column 2 is index 1.

SELECT V_English FROM T07_F2 WHERE V_English LIKE [comboboxname].Column(1) & "*";

Many thanks for the help.

I tried it but sounds not work with me.

I got the message “undefined function ‘comboboxname.column’ in expression.

The attached screenshots show how my tables are linked to each other

Where might be my mistake?

[June7]

'comboboxname' is just a generic reference for example. Use your real combobox name.

[jamal numan]

'comboboxname' is just a generic reference for example. Use your real combobox name.

Sorry for bothering you again.

I couldn’t know how to customize the code you have already sent to me in terms of the name of the combo box. By what should I replace the name of the “comboname” to make it work?

What might be the proper code in terms of the names of my tables and fields? Please, kindly have a look on the attached screenshot

Thank you

[June7]

I NEVER build lookups in tables. I only do it in combo and list boxes on forms.

Dependent combobox won't work in table because requires some code to refresh the RowSource after selection in first combobox (unless Data Macro can do that - never used Data Macro).

[jamal numan]

I NEVER build lookups in tables. I only do it in combo and list boxes on forms.

Dependent combobox won't work in table because requires some code to refresh the RowSource after selection in first combobox (unless Data Macro can do that - never used Data Macro).

many thanks for the input.

best

Jamal

[June7]

And on review, looks like I referenced wrong fieldname in the second combobox RowSource:

SELECT M_English FROM T07_F2 WHERE M_English LIKE comboboxname.Column(1) & "*";

or using the F1_Value field:

SELECT M_English FROM T07_F2 WHERE F1_Value = comboboxname.Column(1);

[jamal numan]

And on review, looks like I referenced wrong fieldname in the second combobox RowSource:

SELECT M_English FROM T07_F2 WHERE M_English LIKE comboboxname.Column(1) & "*";

or using the F1_Value field:

SELECT M_English FROM T07_F2 WHERE F1_Value = comboboxname.Column(1);

Many thanks June7.

The problem persists to exist! Sounds that I don’t have sufficient capabilities to customize the codes you have already supplied to make them fit well with my tables.

Best

Jamal

[June7]

Don't do on tables, build forms.

[jamal numan]

Many thanks June for the continuous help.

Best

Jamal