Hi Guys
I am embarking on a new database
I have a main form and a subform/child form that is different for each type of business (see below)
form filter is on main...
If Me.FormFilter = "0" Then
Me.FormLoadX.SourceObject = "NoSchemeSelectedfrm"
End If
If Me.FormFilter = "1" Then
Me.FormLoadX.SourceObject = "TravelQfrm"
End If
If Me.FormFilter = "2" Then
Me.FormLoadX.SourceObject = "OrgQuotefrm"
End If
Now i have cascading combo box (on the child/subform) and I will have a few of these and others that will need to query stuff
the first box works correctly but the second box is not being requeried
as I have only just started this process, I am sure that some of the other qry's I will add on will have the same issue
how do I get the second dropdown/combo box to requery ? look at the first combobox ?
The first dropdown - looks at an table get categories the second should use this result to filter out and allow me to select
first part works second part does not ....
I am embarking on a new database
I have a main form and a subform/child form that is different for each type of business (see below)
form filter is on main...
If Me.FormFilter = "0" Then
Me.FormLoadX.SourceObject = "NoSchemeSelectedfrm"
End If
If Me.FormFilter = "1" Then
Me.FormLoadX.SourceObject = "TravelQfrm"
End If
If Me.FormFilter = "2" Then
Me.FormLoadX.SourceObject = "OrgQuotefrm"
End If
Now i have cascading combo box (on the child/subform) and I will have a few of these and others that will need to query stuff
the first box works correctly but the second box is not being requeried
as I have only just started this process, I am sure that some of the other qry's I will add on will have the same issue
how do I get the second dropdown/combo box to requery ? look at the first combobox ?
The first dropdown - looks at an table get categories the second should use this result to filter out and allow me to select
first part works second part does not ....