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
|
|||
|
|||
Cascading Combo Boxes and Populating a Form
Hi All,
I've been trying to figure this out all afternoon but have hit a wall, so thought best to ask the experts! I have a form that shows information for a particular document (such as revision, title, various dates). What I want to do is have two combo boxes, the first for selecting document number, and the second for selecting a revision within the document number. I'm assuming the first should be an unbound combo box linked to a query, but how do I feed the second combo box with the selection from the first, and then pass on information from both to the form? Also, as a result of these two selections I am trying to show all the other info from the record within the form (but show all as blank unless both combo boxes have a selection). Any help hugely appreciated. Marc |
#2
|
|||
|
|||
Cascading Combo Boxes and Populating a Form
Marc,
Have a look at... http://www.mvps.org/access/forms/frm0028.htm As for part two, sounds like you will need a form/subform tying the subform to the combo boxes, hence not showing the results until both are filled in. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marc T" wrote in message ... Hi All, I've been trying to figure this out all afternoon but have hit a wall, so thought best to ask the experts! I have a form that shows information for a particular document (such as revision, title, various dates). What I want to do is have two combo boxes, the first for selecting document number, and the second for selecting a revision within the document number. I'm assuming the first should be an unbound combo box linked to a query, but how do I feed the second combo box with the selection from the first, and then pass on information from both to the form? Also, as a result of these two selections I am trying to show all the other info from the record within the form (but show all as blank unless both combo boxes have a selection). Any help hugely appreciated. Marc |
#3
|
|||
|
|||
Cascading Combo Boxes and Populating a Form
Hi Gina,
thanks for the tip and link! I think I have it figured out now, just need to make the form etc a bit easier on the eye now. Marc "Gina Whipp" wrote: Marc, Have a look at... http://www.mvps.org/access/forms/frm0028.htm As for part two, sounds like you will need a form/subform tying the subform to the combo boxes, hence not showing the results until both are filled in. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marc T" wrote in message ... Hi All, I've been trying to figure this out all afternoon but have hit a wall, so thought best to ask the experts! I have a form that shows information for a particular document (such as revision, title, various dates). What I want to do is have two combo boxes, the first for selecting document number, and the second for selecting a revision within the document number. I'm assuming the first should be an unbound combo box linked to a query, but how do I feed the second combo box with the selection from the first, and then pass on information from both to the form? Also, as a result of these two selections I am trying to show all the other info from the record within the form (but show all as blank unless both combo boxes have a selection). Any help hugely appreciated. Marc . |
#4
|
|||
|
|||
Cascading Combo Boxes and Populating a Form
Marc,
Glad to help! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marc T" wrote in message ... Hi Gina, thanks for the tip and link! I think I have it figured out now, just need to make the form etc a bit easier on the eye now. Marc "Gina Whipp" wrote: Marc, Have a look at... http://www.mvps.org/access/forms/frm0028.htm As for part two, sounds like you will need a form/subform tying the subform to the combo boxes, hence not showing the results until both are filled in. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marc T" wrote in message ... Hi All, I've been trying to figure this out all afternoon but have hit a wall, so thought best to ask the experts! I have a form that shows information for a particular document (such as revision, title, various dates). What I want to do is have two combo boxes, the first for selecting document number, and the second for selecting a revision within the document number. I'm assuming the first should be an unbound combo box linked to a query, but how do I feed the second combo box with the selection from the first, and then pass on information from both to the form? Also, as a result of these two selections I am trying to show all the other info from the record within the form (but show all as blank unless both combo boxes have a selection). Any help hugely appreciated. Marc . |
Thread Tools | |
Display Modes | |
|
|