Hi there
Wonder if anyone can help me?
I have 2 combo boxes (cboCompanyName) & (cboDate) working as cascading combo boxes to filter a query. I have it so that when a selection is made in (cboCompanyName) the relivant dates populate (cboDate). Now I want it to also work the other way round....i.e. when a selection is made in (cboDate) the relivant Company Names are populated in (cboCompanyNames)
Also, is there a way I can have it that when no selections are made in either combo boxes the query will show ALL records. Then if a selection is made in (cboCompanyName) and not in (cboDate) the query will show All records for that Company. And finally if a selection is made in (cboDate) and not in (cboCompanyName) the query will show ALL records for that Date
Thank you very much in advance