If a queryvfinds no records (1 Viewer)

[Bobp3114]

I have a combo box "cboOpportunity", run by a query :qryActivityOpportunity" which simply looks to find records linked to the value of "cboCompany"
cboOpportunity is set to Limit to List and is a bound combo
I wish to add the phrase "No Opportunity" when the query finds no records

 

[theDBguy]

There's a couple of approaches here.

Forms: Adding "All" to a listbox or combobox