combobox filter in same combobox

[Jims Chan]

Hi guys,

i have a combobox A in form A and combobox B in subform B (where is continous), selection in combobox A will cascading the list in combobox B.
For Combo B ( pineapple, orange, apple....), lets say if 1st record had selected for orange, can 2nd record filter the orange to be dissapear?

[ranman256]

not sure of the question,....
what is selected in cbo A? orange?
then what does cbo B have in the list?

or is cbo A, fruit?
then cbo B (( pineapple, orange, apple....)
then select Orange in cbo B to filter subform?
if THIS is the case, then cboA Afterevent, will reset the cboB rowsource.

sub cboA_AfterUpdate()
   if IsNull(cboA) then
        me!subform!form!cboB.rowsource = "qsAll"
   else
        me!subform!form!cboB.rowsource = "qsFilterB"
   endif
end sub

THEN, when you pick the item in cboB, filter the items in the subform

sub cboB_AfterUpdate()
   if IsNull(cboB) then
        me.FilterOn = false
   else
        me.filter = "[field]='" & me.cboB & "'"
        me.FilterOn = true
   endif
end sub

[Jims Chan]

Thanks ya bro
Actually, combobox A is category of fruit, food, drink
while combobox B is sub category of comboboxA...
for same record in mainform, combobox B record in subform cannot not be duplicate...
I try the code before, it not working...

[aytee111]

The query row source of combobox B would have as a criteria <>Forms!MainFormName!ComboboxA