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
|
|||
|
|||
Query based on a combobox on a subform in a subform
Hello
I have a subform witin a subform. In that subform are two comboboxes. I would like to know how to get the list in combobox 2 to be dependent on combobox 1. Specifically, box 1 is measurement_unit_type with values: "Time", "Distance", "Mass" etc.. Once this is selected. I would then like the contents of box 2 to be filtered so that if, for example "Time" is selected, the values would be "seconds", "hours", "days", if Mass is seleted, then the values would be "grams", "kilograms", etc.. I have made a table as such; Time | seconds Time | hours Time | days Mass | miligrams Mass | grams Mass | kilograms .... The problem, I think is that the combo boxes are in a subform on a subform. Does anyone know how I could get this to work? I've tied building a query with the following as criteria, but it doesn't work Forms![frm_mainform].[frm_subform1].[frm_subform2].Form! [cmb1measurement_unit_type] Any help would be appreciated |
#2
|
|||
|
|||
Query based on a combobox on a subform in a subform
|
#3
|
|||
|
|||
Query based on a combobox on a subform in a subform
Hi John
I've got it working using your SQL method. I had to tweek the code a little by changing Me!cboUnit_Type to Me.cboUnit_Type.Text and it seems to work really nicely. Thanks Tony |
#4
|
|||
|
|||
Query based on a combobox on a subform in a subform
|
Thread Tools | |
Display Modes | |
|
|