3 Combo-box 1 sub form filtering

[raffi]

hello i have 3 combo-box's which have 3 master fields linked to a sub form's child fields, which are filtering 3 of the combo-box's value's, is it possible to disable the filter if the combo-box is equal to blank ?



even tho all 3 combo-box's have been assigned to filter the sub-form, i want to be able to filter with one combo-box, by disabling other 2 combo-box's only when they are blank and have no value in them


thank you

[burrina]

You would need to write a If Statement for this. Example: This should give you an idea.

If (Me.MyCombo) = "Something" Or IsNull (Me.SomeOtherCombo) Then
Me.SomeOtherCombo.Enabled = False
Else
Me.SomeOtherCombo.Enabled = True
End If

HTH

[raffi]

hm, great idea, hmmm how can i apply this to the if combobox = isnull then disable filter sort of a formula lol

[burrina]

Hmm, this may work for you. If not, we can try something else. Let us know.

Me.FilterOn = False
Me.Filter = vbNullString
Me.OrderByOn = False
Me.OrderBy = vbNullString

HTH

[raffi]

im extreamly sorry for the unintelligent question but where am i suppose to write that formula cuz it seems like a VBA code and i never have written one in access or know where am i suppose to write one

[burrina]

Have you tried any code yet? If so, where? Perhaps upload a sample db for analysis! Someone would be willing to help.