Welcome to the forum and thanks for using code tags!
Not sure which table is what here - kinda confusing
I have a combobox to select the
Booth Name of which
Show Service belongs to.
Open the query in design view, change the joint to outer (either option 2 or 3). Can't say which for sure, but probably would end up being a left join. See which version gives you the desired results. If neither, there could be other issues (a calculated short text name value?).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.