Hi All,
I didn't want to start a new thread but I could use some help with an issue I've been facing. I have a combo box in a form that filters a subform based on a field called Status. I am currently using a table that stores each status for the combo box selection. Since the status field is not always populated, I was asked to add a blank section in the combo box in order to filter the subform where the Status field is blank. I tried adding a the blank with a query and I tried just adding a blank to the table but neither is filtering the subform. How do I add a blank or null to the table selection for the combo box that can filter the subform? Please advise.
I didn't want to start a new thread but I could use some help with an issue I've been facing. I have a combo box in a form that filters a subform based on a field called Status. I am currently using a table that stores each status for the combo box selection. Since the status field is not always populated, I was asked to add a blank section in the combo box in order to filter the subform where the Status field is blank. I tried adding a the blank with a query and I tried just adding a blank to the table but neither is filtering the subform. How do I add a blank or null to the table selection for the combo box that can filter the subform? Please advise.