Im trying to set up a case situation for my cascading combo.
i have
...
Case "Liquor"
Other_Agenda_Item.RowSource = "Liquor_Other"
Decision_Type.RowSource = "Liquor_Decision"
Nature_Type.RowSource = "Liquor_Nature"
...
but when ever i try to select the drop down box for Decision_Type or Nature_Type, it throws an error saying that it cant find the table, however it never throws it for Other_Agenda.
is it cause the syntax is wrong for this? in that there is nothing to break up the end of the first line and show that the second line is a new line, like there is no ';'.
what do i need to put in there for this error to go away.
or is this error coming up saying that the table doesnt exist another problem/
i have
...
Case "Liquor"
Other_Agenda_Item.RowSource = "Liquor_Other"
Decision_Type.RowSource = "Liquor_Decision"
Nature_Type.RowSource = "Liquor_Nature"
...
but when ever i try to select the drop down box for Decision_Type or Nature_Type, it throws an error saying that it cant find the table, however it never throws it for Other_Agenda.
is it cause the syntax is wrong for this? in that there is nothing to break up the end of the first line and show that the second line is a new line, like there is no ';'.
what do i need to put in there for this error to go away.
or is this error coming up saying that the table doesnt exist another problem/
