If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
three combo boxes
I am in a process of developing a database, but I need to ask many questions
before I get started and then find out that certain functions won't work will be frustrating so here goes my question. Let's say I have a Form that is consisted of many combo boxes and I want particulary 3 combos to synchronize. For example, I have set up three tables (tblBeginningStatus, tblGrade, and tblSecondarySchool); so if I select Beginning status field, I want Grade field to populate based on values of the Beginning status, and when I select secondary school, I want that to populate values from the Grade field. Is this mission possible or impossible? Please anyone if you can help I would highly appreciate it..... |
#2
|
|||
|
|||
three combo boxes
See this website for information on how to "cascade" combo boxes:
http://www.mvps.org/access/forms/frm0028.htm -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "Mani" wrote in message ... I am in a process of developing a database, but I need to ask many questions before I get started and then find out that certain functions won't work will be frustrating so here goes my question. Let's say I have a Form that is consisted of many combo boxes and I want particulary 3 combos to synchronize. For example, I have set up three tables (tblBeginningStatus, tblGrade, and tblSecondarySchool); so if I select Beginning status field, I want Grade field to populate based on values of the Beginning status, and when I select secondary school, I want that to populate values from the Grade field. Is this mission possible or impossible? Please anyone if you can help I would highly appreciate it..... |
Thread Tools | |
Display Modes | |
|
|