Microsoft Access - Linking to the Two Combo Box

Asked By Mohd Ajaz
03-Nov-09 06:47 AM

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

re  re

05-Nov-09 08:40 AM

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

 

 

Create New Account
help
displaying in a grid from Combo box hi. . I have a combo box containing few dates where i can select more than one dates and i want to display the orders for those dates which are checked from the combo box and those orders i want to display in grid view. . . . so plz help me. . . . . . . . . . . . . . . . . . . . . . . . . . . . !!!!!!!!!!!!!!!!!!!!!! You Eval("yourField") %> ' / > < / ItemTemplate> <EditItemTemplate> <%- -Your ComboBox- -%> < / EditItemTemplate> < / asp:TemplateField> < / Columns> < / asp:GridView> I needed a Combo Box in my Data Grid . After looking around on the web, I found many examples, but
Add to combo box DataBase , to, combo, box" / > I have a combo box used to view specific customer records. I would like to add <ALL> to my Search By Date combo box as the default value. Below is my current SQL: SELECT [Customer Query].CustomerID, [Customer Query
Combo box based on anothr combo box DataBase i'm trying to generate a combo box list based on the selection of another combo box. I aslo need to requery the second combo box once a selection is made in
Combo Box DropDown Style .NET Framework Combo Box DropDown Style. A combo box is bound to a data table field name. When combo box has simple / drop down style then bound is successful. Other hand if Combo box has
Showing combo box box that's not an option in its drop-down list DataBase Is it possible to display data in a combo box that is not available as one of its drop-down options? I have a healthcare that tracks patient appointments and the attending doctor. The doctors are listed in a combox box that is supplied by a table (tblDoctors). If a doctor quits, we need to display their previous appointments with the patient in the combo box, but not have them available as a choice for future appointments. I tried to accomplish