Linking to the Two Combo Box

Good morning sir,

Sir THis Ajaz I am working as MS ACCESS prorammer in a reputed company sir I Have a problem in Access please retify below is my Question

Sir ,

   I have creted a form in which Two Lookup(Combo Boc) The Fields names ae (Submuncipality ID and Name and District ID and Name). SO my problem is when a user click on a Submuncipality name in the other (District ID and Name) field all the Name of Concern district must be open.

Sir please by takein you owqn example please send me the reply sir I need you help sir I am waiting for yoou solution tnking you

See the sample code here. here two list boxes when you selecting the first list box second will display the data as per your selection.Insert the code in the even of click/change etc. the following code is only for query second list box.(assume first list box having the data)

here 'cid' is the first column data of second list box

list67=first list box.

Dim strnewrecord As String
strnewrecord = "SELECT orderno,receiveddate FROM ord WHERE cid =list67"
List84.RowSource = strnewrecord