Combo Box: Value List limited from selection from another combo box

[GraemeG]

Hi,

I have attached the table below from which I require assistance on combo boxes.


The first combo box on the form selects the SOR shortdesc - I then want the second combo box only to show the SOR descriptions which relate to the SOR shortdesc selected in the first combo box.
Is this possible?

Thanks

SOR code

SOR shortdesc

SOR description

CA9613	BOLT	BOLT:RENEW FIRE SECURITY BOLT.
CA9615	BOLT	BOLT:RENEW GLASS TO SEC.BOLT
CA9619	BOLT	BOLT:REMOVE; EASE AND REFIX.
CA9121	CATCH	CATCH:RENEW BRASS CASEMENT.
CA9129	CATCH	CATCH:RENEW A.A CASEMENT.
CA9137	CATCH	CATCH:RENEW ZINC ALLOY CASEMENT.
CA9161	CATCH	CATCH:RENEW LOCKABLE CASEMENT

[GraemeG]

I have this but the second combo box is always blank no matter what I select
from the first box.

First Combo
SELECT [SORV4_BR_DPC].[SOR
shortdesc] FROM SORV4_BR_DPC GROUP BY [SORV4_BR_DPC].[SOR shortdesc];

Private Sub
cboFrontLoungeDPC_ShortDesc_AfterUpdate()
Me.cboFrontLoungeDPC_Description = vbNullString
Me.cboFrontLoungeDPC_Description.Requery
End
Sub


Second Combo
SELECT
SORV4_BR_DPC.[SOR description] FROM SORV4_BR_DPC WHERE (((SORV4_BR_DPC.[SOR
shortdesc])=[Forms]![subMOT_FrontLounge]![cboFrontLounge_DPC_ShortDesc])) ORDER
BY SORV4_BR_DPC.[SOR description];