Posted to another forum where the answer which worked:
[Forms]![mainmenu].[searchCombo1] OR [Forms]![mainmenu].[searchCombo1] Is Null
Thanks Chrafangau for your help
Hi guys,
I have developed a league registration system for a SE London Veterans Associated Football league. (Edit: I am using Access 2003)
The system is currently searchable by clicking a dropdown box at the top which the queries refer to.
However a new team has just joined which has a...