Sub Form (child) Query issue

[GaryPanic]

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 ....

 

[Ranman256]

assuming me.formfilter IS a string:

SELECT CASE  Me.FormFilter
   case "0"
      Me.FormLoadX.SourceObject = "NoSchemeSelectedfrm"

   case "1"
      Me.FormLoadX.SourceObject = "TravelQfrm"

   case  "2" 
      Me.FormLoadX.SourceObject = "OrgQuotefrm"

End select

 

[GaryPanic]

thanks - however, that's not the problem
the problem is the queries /queries are not working on the sub/child forms..

 

[GaryPanic]

THat's right - stand alone fine - child /sub is the issue - what I will do is trim d/b and upload

uploaded..

 

[GaryPanic]

uploaded d/b in previous post..

 

[GaryPanic]

Sorry
they are cascading combo boxs

the first selects from a table the second should be filtered by the first selection- fine as a stand alone but once a sub/child form -
does not work

i have tried various options
updating a field on the underlying table and using this as a filter for the second combobox
that didn't work ..

 

[GaryPanic]

I will give this a try later on today /tonigh

How is sunny Newbury

 

[CJ_London]

took a look at your uploaded db and cannot see where the problem is - no code, no controls called FormLoadX or formfilter. Can't even find a form with a subform

So unable to help

 

[GaryPanic]

weird ..

this works
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


However when you go to the second record(12345) and on the endorsement tab there are two combo boxes the first one works the second one does not