Continuous Form Cascading Combo

[pulsarman605]

I have a query/table with

LNAME	STOCKCODE	batchcode
Darwin	ABCSU	SSCU151010
Darwin	ABCU	2017060113
Darwin	ABUSQ	LT 1023
Sydney	ABSGU	2018221
Derrimut	ABSGU	2018221
Perth	ABSGU	2018221
Brisbane	ABSGU	2018221
Adelaide	ABSGU	2018221

<caption>
</caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>

I want on a single row. A drop down for LNAME (distinct), then a dropdown for STOCKCODE based on LNAME, THEN BATCHCODE based on STOCKCODE and LNAME.

Can this be done????

 

[pulsarman605]

Doesn't matter..... I think I worked it out... ADMIN please delete post