Null Values on Cascading Combo Box

Question

Hi,

I'm a complete newbie to Access so I apologize if I am not clear enough.

I have created two cascading combo boxes in which the second one runs off of the information selected in the first one. the First Box is named "ComboSoldToParty" and the Second one is "ComboProgram". I am filtering a query that has a sold-to party column and a program column that is relevant to specific sold-to parties. I can correctly filter whenever I select a record from each combo box, however I wanted to know how to return all records for the value selected in the first combo box if there is no or null value in the second box.

Here is what I have in VBA:

Private Sub ComboSoldToParty_AfterUpdate()

Me.ComboProgram.Requery

End Sub

Private Sub FilterBySTP_Program_Click()

Call DoCmd.OpenQuery("FilterBySTP&Program", acViewNormal, acReadOnly)

End Sub

And here is what I have in the criteria field in the STP column in the query that filters the data based on the combo boxes:

[Forms]![FilterByEmployeeOrSTP]![ComboSoldToParty]

Maybe there is something I need to enter in the query in the Program Column too? Any help would be appreciated.

Answer 1

Enter the following in the Criteria row of the Program field:

[Forms]![FilterByEmployeeOrSTP]![ComboProgram] Or [Forms]![FilterByEmployeeOrSTP]![ComboProgram] Is Null

When you save and close the query, Access will rearrange the criteria; that is OK.