Cascading Combo on Continuous Form

[Homegrownandy]

I have set up a cascading combo box for a continuous form (as the title suggests).

It's working only for the first record, I'm unsure what to change to make it row specific.



The combo box runs off this query:

SELECT ProjectT.Client_ID, ProjectT.Project_Name
FROM ProjectT
WHERE (((ProjectT.Client_ID)=[Forms]![Menu].[Form]![Order_Tbl]![CmbCompnay]));

[CmbCompnay] does have a requery event and all is working fine but only on the first row/record of the form. Any advice appreciated.

Andy.

[Homegrownandy]

Ive been doing som reading and this seems very complicated. Im happy enough having a button that opens a form for that record only. So unless someone has an easy solution to had dont worry about it.
Thanks.

[CJ_London]

this link may help
https://www.access-programmers.co.uk...s-form.275155/

the reason it is not working for you is that it is, but using the wrong values - they need to be refreshed for the row you are on - but then they will be wrong for the other rows.

[Homegrownandy]

Thanks a lot Ajax