Query string to resolve dependant combo box in subform

Good morning fellow Access devs,

On my Mainform is a Subform with two combo boxes: Combo A and Combo B. Combo B is dependant on the selection made in Combo A.

My sql string as follows.

SELECT Table.Field1 AS Expr1, Table.Field2 AS Expr2
FROM Table
WHERE (((Table.Field1)=[Forms]![MainForm]![SubForm].[Form]![ComboBox A]))
ORDER BY Table.Field1;

When I run this from the query (i.e not from the main form), I enter the correct paramenters and the query returns the correct information.

When I run this from the mainform, I select the value in Combo A (which runs a requery for Combo B). Combo B however, is not populating as expected.

What could be the problem?

I've tried: WHERE (((Table.Field1)=[Forms]![SubForm]![ComboBox A])). This works on another project, but i can't see why it wouldn't on this one.

Any suggestions?

Good afternoon fellow Accessians,

While there was no answer to this question, it turns out that the issue was with the bound column of Combo box A.

The form is now working correctly as intended, and I'm closing off the issue as solved.

Cheers

Good afternoon fellow Accessians,

While there was no answer to this question, it turns out that the issue was with the bound column of Combo box A.

The form is now working correctly as intended, and I'm closing off the issue as solved.

Cheers